Can I continue exporting data despite the snapshot too old error?

Question

I am exporting a schema from Oracle production database to create a new, test database.

Unfortunately, I received the error ORA-01555: snapshot too old

Despite the error, export still in progress .dmp file is growing.

I don't care about the consistency and quality of the data - The application team will test some tested migrations.

Can I continue and be able to import this data into my new test database?

Answer 1

See Oracle Support Doc ID 452341.1. This is most likely caused by corrupted LOB files and will require a physical recovery from backup. The Doc has specific steps to verify which LOBs are affected and correct the issue.