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.