Which tables do not have indexes in Oracle?

Question

On Oracle, how can I list ALL tables and ALL materialized views without indexes using a SELECT command ?

Answer 1

Well, normally I wouldn't do this, but here you go:

SELECT t.TABLE_NAME
  FROM USER_TABLES t
  LEFT OUTER JOIN (SELECT DISTINCT TABLE_NAME
                     FROM USER_INDEXES) i
    ON i.TABLE_NAME = t.TABLE_NAME
  WHERE i.TABLE_NAME IS NULL;

Perhaps your question should be "Why did someone just do my homework for me?".

Best of luck.