Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXPDP BLOB - ORA-01555

773821May 19 2010 — edited May 19 2010

Hello

I want to export my blob table. The table has 190 GB. My problem is, that i receive a ORA-01555 (snapshot to old) error after 6 hours and 174 GB. the parameter undo_retention is set to zero. What can I do, that I can export my blob? My undo tablespace is 3 GB and autoextend, when i monitor my undo tablespace, he will be never full.

This is a Oracle 10.2 Database on Windows 2003 Server.

thanks for your support.

roger

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2010

Added on May 19 2010

#database-key-features, #export-import-sql-loader-external-tables

8 comments

3,087 views