Wednesday, March 2, 2011

How to resolve below impdp errors in RAC environment ?

error :
ORA-31693: Table data object %S failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-11010: unable to open at least one dump file for load

Solution
1. Create the Data Pump directory on a shared storage accessible from all the instances in the RAC cluster.
OR
2. Run the Data Pump import job with parallel=1 (default)
OR
3. Run the Data Pump import job from one instance and shutdown all reaining instances.

No comments:

Post a Comment