ORA-02298: 无法验证 - 未找到父项关键字

@$ORACLE_HOME\RDBMS\ADMIN\utlexcpt.sql;

EXCEPTIONS 子句帮助识别违反约束的行

TRUNCATE TABLE EXCEPTIONS;
ALTER TABLE "SCOTT"."ADDRESS" ADD FOREIGN KEY ("PARENTADDRESSID") REFERENCES "SCOTT"."ARDADDRESS" ("ID") ENABLE  EXCEPTIONS INTO exceptions;


select * from ADDRESS where rowid in (select row_id from exceptions);