select a.table_name
from user_tables a
where not exists ( select ‘x’ from user_constraints b
where b.table_name = a.table_name
and b.constraint_type = ‘P’);
select a.table_name
from user_tables a
where not exists ( select ‘x’ from user_constraints b
where b.table_name = a.table_name
and b.constraint_type = ‘P’);