index rebuild -- snap shot too old error [message #4204] |
Mon, 18 November 2002 08:42 |
Gopala K Tasupalli
Messages: 14 Registered: October 2002
|
Junior Member |
|
|
Hi
I am trying to rebuild my indexes, all indexes are rebuild except one index! i am getting the following error is there a solution for this?
ORA-01555: snapshot too old: rollback segment number 4 with name "RBS03" too small
Gopal
|
|
|
Re: index rebuild -- snap shot too old error [message #4205 is a reply to message #4204] |
Mon, 18 November 2002 08:49 |
satish
Messages: 112 Registered: September 2000
|
Senior Member |
|
|
Hi,
whenever its trying to extend the segement your rolback segment size is not sufficient, so have frequent commits in your application or
extend the size of the rollback segment or use a big rollback
segment and specify oracle to use that rollback segment like
giving the statemnet set transaction use rollback segment and then try to rebuild the index.
Regards,
Satish.
|
|
|
|