CODEWITHSUNDEEP
oracle-databaseexpdp
Karol
Karol

Reputation: 117

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

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?

Upvotes: 0

Views: 552

Answers (1)

pmdba
pmdba

Reputation: 7033

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.

Upvotes: -1

Related Questions