ORA-00955,ORA-39120, ORA-02266 -Import Error due to referenced constraints Tips

on

Errors:

ORA-00955: name is already used by an existing object
ORA-39120: Table "OWNER"."TABLE_NAME" can't be truncated, data will be skipped. Failing error is:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

Most frequently we encounter issues while importing the dumps due to reference constraints which doesn't allow to insert data into the tables .

Solution:

Disable all the constraints related to the owners and reimport .To Findout constraints enabled on the tables use the below query .

select 'alter table '||a.owner||'.'||a.table_name||' disable constraint '||a.constraint_name||';'
from all_constraints a, all_constraints b
where a.constraint_type = 'R' and a.status='ENABLED'
and a.r_constraint_name = b.constraint_name
and a.r_owner  = b.owner
and a.r_owner = '&OWNER';

 Disable the constraints and rerun the import .Once import completed please re-enable the captured constraints .




Appreciate Comments & Feed backs !! 


Comments

Post a Comment