Re: Fail to extend rollback segment ?

Gary Assa wrote:
>
> >>when I insert 200,000 records into a table from a query, I encounter
> >>the following errors.
 

> >>ORA-01562: failed to extend rollback segment (id = 1)
> >>ORA-01628: max # extents (121) reached for rollback segment RB_TEMP
 

> >>I have added a datafile size 20M (total is 35M)
> >>and increase the initial to 1M and next to 500K on ROLLBACK_DATA
>
> 500k is a ridiculously small NEXT for such a big INSERT. I'd make an initial
> of 10M and a NEXT of 5M, this way you get over 500M before you run out
> of extents.

The original message indicates that “I have added a datafile size 20M (total is 35M)”

Thus when you say “this way you get over 500M before you run out of extents.” I think with 35M you would run out of extents long before 500M  

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~ Gary Piper ( gpiper_at_ozemail.com.au )
http://www.ozemail.com.au/~gpiper/

Phone  : 61-3-9827-4276
Fax    : 61-3-9827-4917
Mobile : 0419-352-584 ( International 61-419-352-584 )
----------------------------------------------------------------------