RE: ORA-01650, one idea
- From: <k.sriramkumar@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Feb 2004 10:20:01 +0530
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@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
-----------------------------------------------------------------
Other related posts:
