UDE-00008: operation generated ORACLE error 31626

This one is interesting and do not panic by just seeing these messages in your EXPDP but check the log file and see if it says job successfully completed or not...

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

I was running expdp with nohup in background by appending nohup info into out file and was checking the out file and noticed these errors and felt that the export job really had an issue.

Opened the log file which is from the parameters settings and the log file says its completed successfully!!!

Oracle Doc ID:549781.1 states:
This issue has been discussed in Bug 5969934 EXPDP CLIENT GETS UDE-00008 ORA-31626 WHILE THE SERVER SIDE EXPORT IS OK

ORA-00922: missing or invalid option

Ok, I guess I have to blog about this after facing this number of times.

Whenever your expdp throws an error like this below, then reduce your parallel option in your export and try again that should resolve it.

ORA-31693: Table data object "SCHEMA_NAME"."TABLE_NAME" failed to load/unload and is being skipped due to error:
ORA-00922: missing or invalid option

expdp fails with ora-31693 ora-01555 snapshot too old

Was trying to export (expdp on 10.2.0.4 database) a table which is about 251GB of size with a BLOB column.

The export runs and runs for 15+ hours and then finally fails with:

ORA-31693: Table data object "SCHEMA_OWNER"."LOB_TABLE" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 384 with name "_SYSSMU384$" too small

??? took about 15+ hours to report this???

Reading this metalink Doc ID 787004.1 and it make sense that we might have some corrupted blocks. So, running that pl/sql code given in that article (running since an hour and I already have a bad feeling abt it :( ) to see if it reports any corrupted records and see if I can by pass those and get this exported.

Will update the findings shortly...