Script for listing tables having no primary key oracle 9i I'm looking for a script to find tables within my database that have no primary key.
select table_name from user_tables
minus
select table_name 
from all_constraints
 where (constraint_type ='P' ) and owner='dbSID_here'