A journal of Programming, Technology and Management notes
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