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 Hi 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; E. __________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
