Snapshot too old

[Chucks_k]

If i get the ORA-01555 : Snapshot too old , am i right in increasing either the extent values, minextent values or optimal value?

Thanks,
Chucks_k

[Mr.Hanky]

What are you trying to do Chuck? Is it a select statemnt, a delete?

MH

[Chucks_k]

Its a batch job consisting of updates and inserts..

Thanks

[pando]

you have insert............ as select

[clio_usa]

A better way of doing it is to create rollback segment big enough to hold the transaction without wrapping up. Then assign the transaction to this rollback segment by:

SET TRANSACTION USE ROLLBACK SEGMENT ;

and run your transaction.

To find out how many bytes your trasaction is going to take check here: Here

Hope that helps,



--clio_usa
Senior Oracle DBA
Oracle DBA Forums