Hi,
I performed an full DB export on 12.2.0.1.0 database and imported on other empty 12.2.0.1.0 database.While importing i faced the below error during REF CONSTRAINT creation step..
ORA-39083: Object type REF_CONSTRAINT:"PG0"."R_CLAMPVAL_4534" failed to create with error:
ORA-04021: timeout occurred while waiting to lock object PG0.CLAMP
On checking i don't find any other session was holding lock on this table other than SYS and its a datapump worker process.
After the import i ran the failed sql statements and created thereferential constraints manually.Later i checked the ASH report also during the time frame which showed the event "library cache lock" with sys user.
Does the impdp process is blocking itself??
How to fix or overcome this issue?
Note : It is an long running import of DB size 6TB and it runs more than 12 hours.
Regards,
007