RE: Archiving data into another database

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Wednesday, January 31, 2007 11:22 PM To: rjamya_at_gmail.com
Cc: cjpengel.dbalert_at_xs4all.nl; lucdemanche_at_gmail.com; oracle-l Subject: 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

• 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***
  --
  http://www.freelists.org/webpage/oracle-l