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