[ORACLE] 특정 스키마의 PK, UK 없는 table 조회

select TABLE_NAME from dba_tables where OWNER = 'TEST' and TABLE_NAME NOT IN ( SELECT A.TABLE_NAME FROM USER_CONS_COLUMNS A INNER JOIN USER_CONSTRAINTS B ON A.CONSTRAINT_NAME = B.CONSTRAINT_NAME WHERE B.CONSTRAINT_TYPE IN ('P','U') and COLUMN_NAME like '%%');