If i get the ORA-01555 : Snapshot too old , am i right in increasing either the extent values, minextent values or optimal value?
What are you trying to do Chuck? Is it a select statemnt, a delete?
I remember when this place was cool.
Its a batch job consisting of updates and inserts..
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,
Senior Oracle DBA
Oracle DBA Forums
Click Here to Expand Forum to Full Width