Re: Archiving data into another database

On 1/31/07, rjamya <rjamya_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l