Category: Datapump

ORA-06512, ORA-39127, ORA-01031, ORA-39126, ORA-06502 WHEN IMPORTING FROM A DATABASE WITH THE DATABASE VAULT ENABLED

  SYMPTOMS A datapump import performing through a database link fails when the Database Vault is enabled on a source database. The datapump import fails with the following error stack impdp system/password schemas=XXCMD NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=XXCMD_refresh_07SEP2020.import.log EXCLUDE=statistics … Processing object type SCHEMA_EXPORT/VIEW/TRIGGER ORA-39127: unexpected error…

ORA-31671: Worker process DW00 had an unhandled exception.

  ISSUE During a datapump import you got the error like the following impdp system/password schemas=XXCDB NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=your_logfile.log … Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name “DW00” prematurely terminated ORA-31671: Worker process DW00…

WordPress Theme built by Shufflehound. DBPILOT, Victor Khalturin