[Home] [Help]
280: and read_only_flag IN ('E','A','U','K','M'))
281: AND NVL(dt.temporary, 'N') = 'N'
282: AND NVL(dt.iot_type, 'X') NOT IN ('IOT', 'IOT_OVERFLOW')
283: AND NOT EXISTS ( select ds.table_name
284: from all_snapshots ds
285: where ds.owner = dt.owner
286: and ds.table_name = dt.table_name)
287: AND NOT EXISTS ( select dsl.log_table
288: from all_snapshot_logs dsl