Monday, July 11, 2016

Error during impdp in 11g - ORA-31693, ORA-29913, ORA-38301



While importing data (using iimpdp. DB is 11.2.0.4)  i was getting the below errror:

ORA-31693: Table data object "SCHEMA"."TABLE":"PARTITION_P1" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

Solution:

Go for purging the dba recyclebin. TO purge dba recyclebin your dba user need to have alter system previlege.



SQL> purge dba_recyclebin;

DBA Recyclebin purged.

No comments:

Post a Comment