Snapshot too old

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

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

MH

Its a batch job consisting of updates and inserts..

Thanks

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

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