Skip to content
Home » Oracle » How to Resolve ORA-31693: Table data object failed to load/unload and is being skipped due to error

How to Resolve ORA-31693: Table data object failed to load/unload and is being skipped due to error

ORA-31693

Found errors when import data from a dump file by using data pump.

ORA-31693: Table data object "ERPAPP"."MONTHLY_PAYMENT" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-20100: Database Error 100 occured while Fetching batch_issue from pay_batch_fix in PAY_ISSUE_TG
ORA-04088: error during execution of trigger 'ERPAPP.PAY_ISSUE_TG'

Seems that a trigger blocked our way to load data.

Solution

To solve ORA-31693, just disable the problematic trigger.

SQL> alter trigger ERPAPP.PAY_ISSUE_TG disable;

Trigger altered.

After all data has been imported, we can enable it back.

SQL> alter trigger ERPAPP.PAY_ISSUE_TG enable;

Trigger altered.

To know more parameters of impdp command, you may take a look.

Leave a Reply

Your email address will not be published. Required fields are marked *