Home » RDBMS Server » Server Administration » snap shot error
snap shot error [message #190150] Tue, 29 August 2006 07:40 Go to next message
preejo
Messages: 2
Registered: August 2006
Location: INDIA
Junior Member

any one can explain snapshot too old error?

Report message to a moderator

Re: snap shot error [message #190183 is a reply to message #190150] Tue, 29 August 2006 10:26 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
visit http://asktom.oracle.com & do a keyword search on ORA-01555.
most common clause of snapshot too old is a COMMIT inside a cursor loop.

Report message to a moderator

Previous Topic: Creating a new database causing errors
Next Topic: unable to start asm database with dbstart
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 08 19:49:41 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.