Find all the tables which are not indexed:
SELECT t.TABLE_NAME
FROM DBA_TABLES t
LEFT OUTER JOIN (SELECT DISTINCT TABLE_NAME
FROM DBA_INDEXES) i
ON i.TABLE_NAME = t.TABLE_NAME
WHERE i.TABLE_NAME IS NULL;
SELECT t.TABLE_NAME
FROM DBA_TABLES t
LEFT OUTER JOIN (SELECT DISTINCT TABLE_NAME
FROM DBA_INDEXES) i
ON i.TABLE_NAME = t.TABLE_NAME
WHERE i.TABLE_NAME IS NULL;
No comments:
Post a Comment