RE: ORA-01650

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Tue, 17 Feb 2004 09:42:00 -0800
Message-ID: <791D0E1ECDECD04D89205F33806FC38701E91BB2@temmse06.tem.guidant.com>

Commit....commit....commit

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

From: solbeach_at_cox.net [mailto:solbeach_at_cox.net] Sent: Tuesday, February 17, 2004 9:23 AM 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 - 11:42:00 CST