Wednesday, September 7, 2011

Query to get a list of tables without any indexes

SELECT table_name
  FROM (SELECT table_name FROM user_tables
        MINUS
        SELECT table_name FROM user_indexes) orasnap_noindex
 WHERE table_name LIKE 'HSO%'
ORDER BY table_name

No comments:

Post a Comment