Re: Archiving data into another database

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: rjamya@xxxxxxxxx
  • Date: Wed, 31 Jan 2007 09:51:42 -0800

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

Other related posts: