Tables With No PRIMARY KEY PK

 

Tables With No PK

NO PRIMARY KEY NOTES:

Table Owner - Owner of the table

Table Name - Name of the table

select  OWNER,
 TABLE_NAME
from    dba_tables dt
where   not exists (
        select  'TRUE'
        from    dba_constraints dc
        where   dc.TABLE_NAME = dt.TABLE_NAME
        and     dc.CONSTRAINT_TYPE='P')
and  OWNER not in ('SYS','SYSTEM')
order by OWNER, TABLE_NAME