Folks The respective little script to dump contents of any table to a sqlldr dumpfile and automatically creating a control file - Could any of you folks possibly share its Link please? Cheers ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still Sent: Wednesday, January 31, 2007 11:22 PM To: rjamya@xxxxxxxxx Cc: cjpengel.dbalert@xxxxxxxxx; lucdemanche@xxxxxxxxx; oracle-l Subject: Re: Archiving data into another database On 1/31/07, rjamya <rjamya@xxxxxxxxx> wrote: Carel has the correct question. Why? However, we do this at my place, and here is how I did it. 1. I went to JaredStill.com and shamelessly copied the scripts to dump contents of any table to a sqlldr dumpfile and automatically creating a control file. No shame required. This has been running fine for over 2 years (three cheers for "cron") , never ever had to change the scripts again. Oh yeah ... thanks Jared. You're welcome. :) That little script is the single most popular database thing I have ever done. Amazing. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***