Requires Free Membership to View
I mentioned this advice in the following question: http://searchoracle.techtarget.com/ateQuestionNResponse/0,289625,sid41_cid554702_tax294550,00.html
If you read that question and answer, you will see that I was specifically responding to the user getting ORA-1555 and ORA-22924 errors when performing the export. The ORA-1555 error is a Snapshot Too Old message. The export operation requires some level of consistency. The level of consistency is determined by the CONSISTENT parameter. Consistency in the Oracle database is resolved with the rollback (or undo) segments. The ORA-1555 errors occur when a transaction that has committed is overwritten in the rollback segment, but your transaction needs that information for read consistency. Once that information is lost, the current transaction throws the ORA-1555 error.
The most common methods to resolve that error are to use a larger optimal value on your rollback segments, or add more rollback segments. The reason that shrinking before you begin your import can help you from receiving ORA-1555 errors is that space is freed up in the rollback segments' tablespace which means that old transaction information *may* not be as easily overwritten. It does not guarantee that the ORA-1555 errors will not occur.
If you search Metalink for ORA-1555 errors, you should find that all three recommendations that I made in response to this specific question are found as suggested solutions to the problem. Shrinking rollback segments does not help export processes, but it can help export processes that experience ORA-1555 errors.
This was first published in July 2004
Join the conversationComment
Share
Comments
Results
Contribute to the conversation