Home » RDBMS Server » Server Administration » ORA-1555 Error
ORA-1555 Error [message #140104] Fri, 30 September 2005 19:29 Go to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member


Hey

Can Someone help me rectify this error...

ORA-01555: snapshot too old: rollback segment number 8 with name
"_SYSSMU8$" too small
EXP-00008: ORACLE error 1555 encountered
EXP-00000: Export terminated unsuccessfully

I had actually scheduled an export backup........Script has been written by the previous DBA..Well i would be very obliged if someone knows the solution to this and could provide me a step by step(Queries will be very helpful)solution.

Thanks
Manjunath
Re: ORA-1555 Error [message #140191 is a reply to message #140104] Sun, 02 October 2005 03:28 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

ORA-01555: snapshot too old: rollback segment number string with name "string" too small 

Cause: Rollback records needed by a reader for consistent read 
are overwritten by other writers. 

Action: If in Automatic Undo Management mode, increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments. 


Oracle says

 When using Oracle Export utility, setting CONSISTENT=Y 
creates a read-consistent export. That is the export is 
consistent to a single point in time. This requires the 
retention of rollback segments if transactions modify the data 
while the export is in progress. Set CONSISTENT=N if you dont 
need a read-consistent export of if a large volume of the data 
will be modified during the export. Also, schedule exports 
during off-peak hours.



Can read this discussion also.

Hope this might help you.

regards,
tarun

[Updated on: Sun, 02 October 2005 03:30]

Report message to a moderator

Previous Topic: Insert problem on 10g?
Next Topic: View version of Oracle database via SQL?
Goto Forum:
  


Current Time: Fri Jan 10 10:33:26 CST 2025