Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Rollback segments

Rollback segments

From: Kochis <djkochis_at_sgi.net>
Date: 1996/12/11
Message-ID: <01bbe786$9e7014c0$79b597ce@orion.sgi.net.sgi.net>#1/1

Trying to delete all the data from a table (6000 records) I recieved the following:

Ora - 1562: Failed to extend rollback segments (Id=1) Ora - 1682: Max # extents (121) reached for rollback segment add_rb

Did I run out of extents and I need to increase max? Did I run out of space in the rollback segment? (same as above?)

Also,
I have three rollback segments created and online. Oracle always seems to use the first one i created? Should I point it to a different one?

thanks in advance for any help
newbie
djkochis_at_sgi.net Received on Wed Dec 11 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US