Re: Rollback segments / ORA-1562 / ORA1628

You have four options: 1. If this is an ongoing daily event (deleting from a table), then increase the size of your current rollback segments. ALTER ROLLBACK SEGMENT "RB3" STORAGE ( NEXT 2M OPTIMAL 3M ); Please replace NEXT and OPTIMAL to your enviroment needs. Also, this must be done to every rollback segment. 2. Create a huge rollback segment and assign it to your session. 3. Use Truncate instead of delete. Truncate deletes the records without going through the redo log buffer. Truncate is unreversable, so use extreme caution. 4. Alter your rollback segments to have a higher/unlimited number of extents. To do this, you must set the parameter unlimited_rollback_segments to equal true (=TRUE) in your init<sid>.ora file.

Good Luck,
Satar
In article <01bdf6c4$7b80bf60$eb58ea9e_at_ukp016543.logica.co.uk>,   "Nick Lehane" <lehanen_at_logica.com> wrote:
> Hi everyone,
>
> I am porting across an updated version of data into an Oracle database
> using Data Manager, which requires the current tables to be empty.
>
> Upon deleting records from these tables I am getting the above error
> messages. For example I have a table called Reference with 77,000 rows.
>
> When I delete these I get the following errors:
>
> delete from reference;
> error at line 1:
>
> ORA-1562 failed to extend rollback segment number 4
> ORA-01628 max # extents (121) reached for rollback segment RB3
>
> These errors come after about 10 minutes which is very strange. I haven't
> created any rollback segments and I don't know much about them. Could
> anyone suggest what I should do to make my database work again?
>
> Many thanks in advance,
>
> Nick Lehane
>
> PS You can reply directly to LehaneN_at_logica.com
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 13 1998 - 14:15:28 CDT