RE: failed to extend rollback segment ??????

From: Martin Kendall <m.kendall_at_ntlworld.com>
Date: Thu, 29 Nov 2001 04:21:55 -0800
Message-ID: <F001.003D03B2.20011129040534@fatcity.com>

Your Rollback Segment is NOT large enough.

You don't have to shut down the DB just yet.

You can remove ALL your test data without an INSERT (which creates RollBack entries) by using TRUNCATE TABLE x where 'x' is the name of your Table.

Martin

-----Original Message-----
sinavalda
Sent: 29 November 2001 11:30
To: Multiple recipients of list ORACLE-L

I have created a test table and I have inserrted about 50000 recoeds in it.

when I want to delete even one record ofthis table receive the following errors:

ORA-01562: failed to extend rollback segment number 3 ORA-01650: unable to extend rollback segment R02 by 64 in tablespace RBS

and also cannot shutdown the DB.

Could someone please tell me what is the problem?

Thanks;

Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: ehsan sinavalda
INET: ehsanoracle_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Martin Kendall
INET: m.kendall_at_ntlworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------