Re: Fail to extend rollback segment ?
From: Gary Assa <gsa_at_li.net>
Date: 1996/10/31
Message-ID: <55akgl$n03_at_linet01.li.net>#1/1
Date: 1996/10/31
Message-ID: <55akgl$n03_at_linet01.li.net>#1/1
>>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.
--
=========================================================
http://www.li.net/~gsa/index.html
This is my signature file, not part of this mail message.
Received on Thu Oct 31 1996 - 00:00:00 CET