Commit....commit....commit -----Original Message----- From: solbeach@xxxxxxx [mailto:solbeach@xxxxxxx] Sent: Tuesday, February 17, 2004 9:23 AM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------