[Home] [Help]
256: where s.owner = p_app
257: and s.table_name = d.table_name)
258: AND NOT EXISTS
259: (SELECT log_table
260: FROM DBA_SNAPSHOT_LOGS L
261: where l.log_owner = p_app
262: and l.log_table = d.table_name)
263: AND nvl(d.iot_type,'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
264: AND NOT EXISTS
285: 'MV_LOG' subobject_type,
286: 'NO' classified,
287: nvl(dt.partitioned,'NO') partitioned
288: FROM dba_tables dt,
289: dba_snapshot_logs dsl
290: WHERE dsl.log_owner = p_app
291: AND dsl.log_owner = dt.owner
292: AND dt.owner = p_app
293: AND dsl.log_table = dt.table_name
424: WHERE s.owner = p_app
425: and s.table_name = dt.table_name)
426: AND NOT EXISTS
427: (SELECT log_table
428: FROM dba_snapshot_logs l
429: where l.log_owner = p_app
430: and l.log_table = d.table_name)
431: and dt.iot_type IS NULL
432: AND NOT EXISTS
754: WHERE s.owner = p_app
755: and s.table_name = i.table_name)
756: AND NOT EXISTS
757: (SELECT log_table
758: FROM dba_snapshot_logs s
759: WHERE s.log_owner = p_app
760: and s.log_table = i.table_name)
761: AND NOT EXISTS
762: (SELECT queue_table
798: WHERE s.owner = p_app
799: and s.table_name = i.table_name)
800: AND NOT EXISTS
801: (SELECT log_table
802: FROM dba_snapshot_logs s
803: WHERE s.log_owner = p_app
804: and s.log_table = i.table_name)
805: AND NOT EXISTS
806: (SELECT queue_table
949: from dba_indexes i
950: where i.table_owner = p_app
951: AND EXISTS
952: (SELECT table_name
953: FROM dba_snapshot_logs s
954: WHERE s.log_owner = p_app
955: and s.log_table = i.table_name)
956: AND I.index_type not in ('DOMAIN','IOT - TOP','CLUSTER','LOB')
957: AND NVL(i.temporary, 'N') = 'N'
970: from dba_indexes i
971: where i.table_owner = p_app
972: AND EXISTS
973: (SELECT table_name
974: FROM dba_snapshot_logs s
975: WHERE s.log_owner = p_app
976: and s.log_table = i.table_name)
977: AND I.index_type ='LOB'
978: AND NVL(i.temporary, 'N') = 'N'
1208: WHERE s.owner = dt.owner
1209: AND s.table_name = dt.table_name)
1210: AND NOT EXISTS
1211: (SELECT log_table
1212: FROM dba_snapshot_logs l
1213: WHERE l.log_owner = dt.owner
1214: AND l.log_table = dt.table_name)
1215: AND NVL(dt.iot_type,'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
1216: AND NOT EXISTS
1239: 'MV_LOG' subobject_type,
1240: 'NO' classified,
1241: NVL(dt.partitioned,'NO') partitioned
1242: FROM dba_tables dt,
1243: dba_snapshot_logs dsl
1244: WHERE dsl.log_owner IN (select oracle_username
1245: from fnd_oracle_userid
1246: where read_only_flag IN ('E','A','U','K','M'))
1247: AND dsl.log_owner = dt.owner
1390: WHERE s.owner = dt.owner
1391: and s.table_name = dt.table_name)
1392: AND NOT EXISTS
1393: (SELECT log_table
1394: FROM dba_snapshot_logs l
1395: where l.log_owner = dt.owner
1396: and l.log_table = dt.table_name)
1397: and dt.iot_type IS NULL
1398: AND NOT EXISTS
1733: WHERE s.owner = i.table_owner
1734: and s.table_name = i.table_name)
1735: AND NOT EXISTS
1736: (SELECT log_table
1737: FROM dba_snapshot_logs s
1738: WHERE s.log_owner = i.table_owner
1739: and s.log_table = i.table_name)
1740: AND NOT EXISTS
1741: (SELECT queue_table
1780: WHERE s.owner = i.table_owner
1781: and s.table_name = i.table_name)
1782: AND NOT EXISTS
1783: (SELECT log_table
1784: FROM dba_snapshot_logs s
1785: WHERE s.log_owner = i.table_owner
1786: and s.log_table = i.table_name)
1787: AND NOT EXISTS
1788: (SELECT queue_table
1942: from fnd_oracle_userid
1943: where read_only_flag IN ('E','A','U','K','M'))
1944: AND EXISTS
1945: (SELECT table_name
1946: FROM dba_snapshot_logs s
1947: WHERE s.log_owner = i.table_owner
1948: and s.log_table = i.table_name)
1949: AND i.index_type not in ('DOMAIN','IOT - TOP','CLUSTER','LOB')
1950: AND NVL(i.temporary, 'N') = 'N'
1966: from fnd_oracle_userid
1967: where read_only_flag IN ('E','A','U','K','M'))
1968: AND EXISTS
1969: (SELECT table_name
1970: FROM dba_snapshot_logs s
1971: WHERE s.log_owner = i.table_owner
1972: and s.log_table = i.table_name)
1973: AND i.index_type ='LOB'
1974: AND NVL(i.temporary, 'N') = 'N'