Thursday, 14 September 2017

UDE-31626: operation generated ORACLE error 31626

Last day ,When i was exporting schemas in oracle database i found a error as UDE-31626: operation generated ORACLE error 31626

Export command used :-
 
EXPDP atlas_appdba/AtlsNonPrd18 DIRECTORY=DATA_PUMP_DIR DUMPFILE=EXPDP_PIN_IFW_PDC_XREF_103_QA_14SEP_%U.DMP COMPRESSION=ALL LOGFILE=EXPDP_PIN_IFW_PDC_XREF_103_PROD_14SEP.log SCHEMAS=PIN103,IFW103,PDC103,XREF103 filesize=30G parallel=4

Error:-

UDE-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3905
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5203
ORA-06512: at line 1

Fix:-


Just run the export command without parallel run, because if the database size is small and if you run the export command with parallel back jobs it may encounter with error as how i got above,

EXPDP atlas_appdba/AtlsNonPrd18 DIRECTORY=DATA_PUMP_DIR DUMPFILE=EXPDP_PIN_IFW_PDC_XREF_103_QA_14SEP_%U.DMP COMPRESSION=ALL LOGFILE=EXPDP_PIN_IFW_PDC_XREF_103_PROD_14SEP.log SCHEMAS=PIN103,IFW103,PDC103,XREF103

No comments:

Post a Comment