908: AND TEMPORARY <> 'Y'
909: AND monitoring ='NO'
910: AND NOT EXISTS
911: (SELECT NULL
912: FROM dba_external_tables de
913: WHERE de.table_name=dt.table_name
914: AND de.owner =dt.owner
915: )-- added this to avoid externale tables being selected
916: AND NOT EXISTS
1395: AND TEMPORARY <> 'Y'
1396: AND monitoring ='NO'
1397: AND NOT EXISTS
1398: (SELECT NULL
1399: FROM dba_external_tables de
1400: WHERE de.table_name=dt.table_name
1401: AND de.owner =dt.owner
1402: )-- added this to avoid externale tables being selected
1403: AND NOT EXISTS