EXP-00056: ORACLE error 1555 encountered

While using the conventional export (exp) utility for exporting the table, following error was seen.

. . exporting table         XXXXXXXXXXXXXXXXXXXXXX      14780 rows exported
. . exporting table                          XXXXX     589614 rows exported
Table XXXXXXXXXX will be exported in conventional path.
. . exporting table                     XXXXXXXXXX
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number  with name "" too small
ORA-22924: snapshot too old
. . exporting table               XXXXXXXXXXXXXXXX        210 rows exported
. . exporting table   XXXXXXXXXXXXXXXXXXXXXXXXXXXX        604 rows exported

These errors are normally seen, when a table with LOB column is exported & the LOB is corrupt. Solution to this problem is described in Metalink Note 787004.1.

This entry was posted in Oracle EXP/IMP and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s