Home » RDBMS Server » Server Administration » Re: snap shoot too old ora 01555
Re: snap shoot too old ora 01555 [message #52506] Fri, 26 July 2002 08:16
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hii,
Genlly this error will come bcos of some mismatch with the Rollback segments..

what happens is a record is updated ,, and the old value is still in the rollback segment..so when u try to retrieve the record, this error will come.. i would suggest you to go for frequent commits..and also reduce the size of Rollback segments...

Byee
sai
Previous Topic: Problem of creating Control File
Next Topic: Re: oracle for windows xp
Goto Forum:
  


Current Time: Wed Sep 18 21:44:31 CDT 2024