Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Rollback segments
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