Hi ,

Actually you try a few options

1. CTAS with 1.6 million records and then truncate the original (with =
drop storage) and reinsert the 1.6 Million records

2. 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)

3. 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@(protected)
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
-----------------------------------------------------------------