1

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?

Karol
  • 127
  • 1
  • 10
  • 1
    Unless you are taking a consistent export (where all tables are exported with the same `as of scn/timestamp`) this error will only be effecting the table it errored against. You can try another export with just this table and see if it runs fast enough a second time - general advice would be to run it during a quiet period so that less undo will be required. Of course, you can also use backups or disk snapshots for this sort of requirement – Andrew Sayer Jun 05 '22 at 11:13

1 Answers1

-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.

pmdba
  • 6,457
  • 2
  • 6
  • 16