[Home] [Help]
891: AND dt.table_name = fets.table_name
892: )
893: AND NOT EXISTS
894: (SELECT NULL
895: FROM dba_external_tables de
896: WHERE de.table_name=dt.table_name
897: AND de.owner =dt.owner
898: ) -- added this to avoid externale tables being selected
899: UNION ALL
932: AND TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
933: AND table_name not like 'DR#%' -- added for Bug 8452962
934: AND NOT EXISTS
935: (SELECT NULL
936: FROM dba_external_tables de
937: WHERE de.table_name=dt.table_name
938: AND de.owner =dt.owner
939: );-- added this to avoid externale tables being selected
940: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
955: AND TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
956: AND table_name not like 'DR#%' -- added for Bug 8452962
957: AND NOT EXISTS
958: (SELECT NULL
959: FROM dba_external_tables de
960: WHERE de.table_name=dt.table_name
961: AND de.owner =dt.owner
962: )-- added this to avoid externale tables being selected
963: AND NOT EXISTS
1001: AND dt.table_name = fets.table_name
1002: )
1003: AND NOT EXISTS
1004: (SELECT NULL
1005: FROM dba_external_tables de
1006: WHERE de.table_name=dt.table_name
1007: AND de.owner =dt.owner
1008: ) -- added this to avoid externale tables being selected
1009: AND NOT EXISTS
1118: AND dt.table_name = fets.table_name
1119: ) -- added by saleem for bug 7479909
1120: AND NOT EXISTS
1121: (SELECT NULL
1122: FROM dba_external_tables de
1123: WHERE de.table_name=dt.table_name
1124: AND de.owner =dt.owner
1125: ) -- added this to avoid externale tables being selected
1126: ORDER BY table_name;
1398: AND dts.owner =dt.owner
1399: )
1400: AND NOT EXISTS -- to avoid external tables
1401: (SELECT NULL
1402: FROM dba_external_tables de
1403: WHERE de.table_name=dt.table_name
1404: AND de.owner =dt.owner
1405: ) -- added this to avoid externale tables being selected
1406: ORDER BY table_name;
1787: AND dt.table_name = fets.table_name
1788: )
1789: AND NOT EXISTS
1790: (SELECT NULL
1791: FROM dba_external_tables de
1792: WHERE de.table_name=dt.table_name
1793: AND de.owner =dt.owner
1794: ) -- added this to avoid externale tables being selected
1795:
1839: AND TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
1840: AND table_name not like 'DR#%' -- added for Bug 8452962
1841: AND NOT EXISTS
1842: (SELECT NULL
1843: FROM dba_external_tables de
1844: WHERE de.table_name=dt.table_name
1845: AND de.owner =dt.owner
1846: );-- added this to avoid externale tables being selected
1847: $IF DBMS_DB_VERSION.VER_LE_9_2 $THEN
1862: AND TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
1863: AND table_name not like 'DR#%' -- added for Bug 8452962
1864: AND NOT EXISTS
1865: (SELECT NULL
1866: FROM dba_external_tables de
1867: WHERE de.table_name=dt.table_name
1868: AND de.owner =dt.owner
1869: )-- added this to avoid externale tables being selected
1870: AND NOT EXISTS
1908: AND dt.table_name = fets.table_name
1909: )
1910: AND NOT EXISTS
1911: (SELECT NULL
1912: FROM dba_external_tables de
1913: WHERE de.table_name=dt.table_name
1914: AND de.owner =dt.owner
1915: ) -- added this to avoid externale tables being selected
1916: AND NOT EXISTS
2030: AND dt.table_name = fets.table_name
2031: )
2032: AND NOT EXISTS -- to avoid extrnal tables
2033: (SELECT NULL
2034: FROM dba_external_tables de
2035: WHERE de.table_name=dt.table_name
2036: AND de.owner =dt.owner
2037: ) -- added this to avoid externale tables being selected
2038: ORDER BY table_name;
2283: AND dts.owner =dt.owner
2284: )
2285: AND NOT EXISTS -- to avoid external tables
2286: (SELECT NULL
2287: FROM dba_external_tables de
2288: WHERE de.table_name=dt.table_name
2289: AND de.owner =dt.owner
2290: ) -- added this to avoid externale tables being selected
2291: ORDER BY table_name;