[Home] [Help]
280: from dba_snapshots ds
281: where ds.owner = dt.owner
282: and ds.table_name = dt.table_name)
283: AND NOT EXISTS ( select dsl.log_table
284: from dba_snapshot_logs dsl
285: where dsl.log_owner = dt.owner
286: and dsl.log_table = dt.table_name)
287: AND NOT EXISTS ( select dqt.queue_table
288: from dba_queue_tables dqt
419: from dba_snapshots ds
420: where ds.owner = dt.owner
421: and ds.table_name = dt.table_name)
422: AND NOT EXISTS ( select dsl.log_table
423: from dba_snapshot_logs dsl
424: where dsl.log_owner = dt.owner
425: and dsl.log_table = dt.table_name)
426: AND NOT EXISTS ( select dqt.queue_table
427: from dba_queue_tables dqt