[Home] [Help]
914: AND de.owner =dt.owner
915: )-- added this to avoid externale tables being selected
916: AND NOT EXISTS
917: ( SELECT NULL
918: FROM dba_tab_statistics dts
919: WHERE dts.stattype_locked IS NOT NULL
920: AND dts.table_name=dt.table_name
921: AND dts.owner =dt.owner
922: ); -- added by saleem to avoid locked objects
922: ); -- added by saleem to avoid locked objects
923: CURSOR lock_stats_tab(schemaname VARCHAR2)
924: IS -- cursor added by saleem to display the warning message for tables with locked stats
925: SELECT table_name
926: FROM dba_tab_statistics
927: WHERE stattype_locked IS NOT NULL
928: AND owner=upper(schemaname); -- added to display the warning for locked stats
929: BEGIN
930: -- Set the package body variable.
994: AND dt.table_name = fets.table_name
995: ) -- added by saleem for bug 7479909
996: AND NOT EXISTS
997: ( SELECT NULL
998: FROM dba_tab_statistics dts
999: WHERE dts.stattype_locked IS NOT NULL
1000: AND dts.table_name=dt.table_name
1001: AND dts.owner =dt.owner
1002: )
1401: AND de.owner =dt.owner
1402: )-- added this to avoid externale tables being selected
1403: AND NOT EXISTS
1404: ( SELECT NULL
1405: FROM dba_tab_statistics dts
1406: WHERE dts.stattype_locked IS NOT NULL
1407: AND dts.table_name=dt.table_name
1408: AND dts.owner =dt.owner
1409: ); -- added this to avoid locked objects
1409: ); -- added this to avoid locked objects
1410: CURSOR lock_stats_tab(schemaname VARCHAR2)
1411: IS -- cursor added by saleem to display the warning message for tables with locked stats
1412: SELECT table_name
1413: FROM dba_tab_statistics
1414: WHERE stattype_locked IS NOT NULL
1415: AND owner=upper(schemaname); -- added to display the warning for locked stats
1416: BEGIN
1417: -- Set the package body variable.
1484: AND dt.table_name = fets.table_name
1485: )
1486: AND NOT EXISTS
1487: ( SELECT NULL
1488: FROM dba_tab_statistics dts
1489: WHERE dts.stattype_locked IS NOT NULL
1490: AND dts.table_name=dt.table_name
1491: AND dts.owner =dt.owner
1492: )