For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
DB version : 11.2.0.4
How can I find all tables without a primary key ? The following query will tables which have primary keys too
select * from user_constraints p WHERE (p.constraint_type != 'P' OR p.constraint_type != 'U')