Data Migration

How to Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keys

  • by
ORA-02266 Got ORA-02266 when import data in schema mode. [oracle@test ~]$ impdp system/password schemas=hr,oe,sh content=data_only table_exists_action=truncate network_link=system_link_orcl … ORA-39120: Table “OE”.”PRODUCT_INFORMATION” can’t be truncated, data… Read More »How to Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keys