RE: ORA-01650

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Tue, 17 Feb 2004 13:40:26 -0500
Message-ID: <E1732F21A9B99440B2117A3BEC76B91D021089@ztangousexch.ad.ztango.com>

create another table save the 1.6 millions you don't want to delete. truncate your table. insert it back using direct path.

-----Original Message-----

From: solbeach_at_cox.net [mailto:solbeach_at_cox.net] Sent: Tuesday, February 17, 2004 12:23 PM To: oracle-l_at_freelists.org
Subject: ORA-01650

I need someone to clarify what I am seeing.

Table contains approximately 6.6 million rows. Each row is no more than 400 bytes.
Want to delete approximately 5 million rows.

Getting the following error message:
ORA-1650: unable to extend rollback segment RBS23 by 1536 in = tablespace RBS

The total size of the RBS tablespace is about 6GB! I do not understand why the RBS is "too small" to accommodate this DELETE.
What, if anything, can be done other than adding another datafile to the tablespace.

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

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


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Feb 17 2004 - 12:40:26 CST