Database Utilities (MOSC)

MOSC Banner

expdp result EXP-00056 , ORA-01555 ORA-22924

edited Apr 2, 2012 3:19AM in Database Utilities (MOSC) 10 commentsAnswered ✓

Hello
Release 10.2.0.3.0

By exporting a table ATTACHMENTDATA with DATA(BLOB) field  with 72586 records (select count(*) from opin.ATTACHMENTDATA)

exp system@ora40 buffer=10000000 FILE=opin.dmp owner=OPIN compress=no log=exp_opin.log
....
i'm  getting
 . . exporting table                 ATTACHMENTDATA
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number  with name "" too small
ORA-22924: snapshot too old

DOC ID 787004.1 indicate how to find corrupt_rowid but after apply teh notice nothing is found.
the CORRUPT_LOBS table is empty .

could you please help to investigate the problem thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center