Your 6GB RBS Ts is probably devided by several rollback segments? What is your rollback segment size? I am guessing you have at least 23 rollback segments, since you have "RBS23"? You could "commit" more often during a delete loop, say every 10K or 5K rows. Or you could copy the 1.6M rows you want to a new table, then truncate the old table, drop the old table, rename the new table to old table. This might be faster. HTH. Guang -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of solbeach@xxxxxxx Sent: Tuesday, February 17, 2004 12:23 PM 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 -----------------------------------------------------------------