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...
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...
No comments:
Post a Comment