Solved

export error

Posted on 2007-04-09
3
750 Views
Last Modified: 2013-12-19

Question:
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.
0
Comment
Question by:imran_fast
3 Comments
 
LVL 4

Accepted Solution

by:
ramumorla earned 400 total points
ID: 18874835
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.

Workaround:
  Regenerate the export file.

0
 
LVL 28

Author Comment

by:imran_fast
ID: 18875193
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.
0
 
LVL 34

Assisted Solution

by:johnsone
johnsone earned 100 total points
ID: 18875608
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.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now