Re: Rollback segments

From: Chris Eastland <chrise_at_shore.net>
Date: 1996/12/12
Message-ID: <58pn7b$rn9@northshore.shore.net>#1/1

"Kochis" <djkochis_at_sgi.net> writes:

>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

Use TRUNCATE ro get rid of all the rows in a table . Received on Thu Dec 12 1996 - 00:00:00 CST