select table_name from user_tables a where not exists (select * from user_constraints b where b.constraint_type = ‘P‘ and a.table_name = b.table_name)
转载:http://blog.itpub.net/20893244/viewspace-2132149/
原文：https://www.cnblogs.com/sweet22353/p/9839399.html