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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
