export error

EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small

The above error is related to rollback segement and retention period but my question is

if i receive this error during export what about the dump file will it contain the data or it is currupted.
LVL 28
Who is Participating?
ramumorlaConnect With a Mentor Commented:
This is due to a Oracle BUG  (Bug 2666174  Export in direct path can product a corrupt export file if ORA-1555 occurs

If direct path export hits an ORA-1555 "snapshot too old ..." error
then the export file may be corrupted by having an "end of table"
marker in the middle of a row.

  Regenerate the export file.

imran_fastAuthor Commented:
i cannot regenerate export file because the data is currupted.
Can i import part of table from the export file. can you provide me with the syntax.
johnsoneConnect With a Mentor Senior Oracle DBACommented:
My first question is was this a direct path export?  Can you show the command you used to export the data?

Did you supply CONSISTENT=Y?  If so, then the export probably terminated when the error was received and the file is missing anything after that and a partial import up to the error may be possible.

If you did not supply CONSISTENT=Y then only the table(s) where this error occurred would have truncated data and anything after them should be OK.

It has been a while since I got this on an export, so I don't remember exactly how it behaves, but I believe this is the way it should work.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.