RE: ORA-01650, one idea

From: <k.sriramkumar_at_iflexsolutions.com>
Date: Wed, 18 Feb 2004 10:20:01 +0530
Message-ID: <10898BE7CA96D611988B000802255AAF051CDA38@fmgrt>

Hi ,

Actually you try a few options

CTAS with 1.6 million records and then truncate the original (with = drop storage) and reinsert the 1.6 Million records
Use a sqlscript to unload 1.6 Million records to a flat file and then = truncate the data and use SQLloader direct path to load the data(there = were some scripts available in metalink for this Pls check)
Use a PL/SQL program to do the deletion

	1.Fetch rowid to be deleted in a array(bulk collect and limit 5000)
	2.Use forall to delete the records using the rowid
	3.commit

4. Export the table with a where clause to filter the 1.6 Million, = truncate and reimport

Best Regards

Sriram Kumar

DISCLAIMER:
This message contains privileged and confidential information and is = intended only for the individual named.If you are not the intended = recipient you should not disseminate,distribute,store,print, copy or = deliver this message.Please notify the sender immediately by e-mail if = you have received this e-mail by mistake and delete this e-mail from = your system.E-mail transmission cannot be guaranteed to be secure or = error-free as information could be =
intercepted,corrupted,lost,destroyed,arrive late or incomplete or = contain viruses.The sender therefore does not accept liability for any = errors or omissions in the contents of this message which arise as a = result of e-mail transmission. If verification is required please = request a hard-copy version.

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 - 22:50:01 CST