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

References:

Archiving data into another database
From: Luc Demanche

Re: Archiving data into another database
From: Carel-Jan Engel

Re: Archiving data into another database
From: rjamya

Re: Archiving data into another database

Other related posts: