Oracle - Encontrando Tabelas sem PKs

Abaixo seguem dois SQLs bem uteis, o primeiro verifica tabelas sem primary key e o segundo se nenhuma primary key está desativada:

1-SELECT table_name FROM all_tables WHERE owner = '&OWNER' MINUS SELECT table_name FROM all_constraints WHERE owner = '&&OWNER' AND constraint_type = 'P';

2-SELECT owner,constraint_name,table_name,status FROM all_constraints WHERE owner = '&owner' AND status = 'DISABLED' AND constraint_type = 'P';