Re: Reg. SQL Loader..

From: Natasha Batson <nbatson_at_neal-and-massy.com>
Date: Mon, 18 Dec 2000 08:19:32 -0400
Message-Id: <10714.124829@fatcity.com>

Arul

Why not use database links as opposed to downloading the data to a flatfile and then performing the SQL Load?

Regards
Natasha

Original Message ----- From: "Arul kumar" <rakumar_at_mahindrabt.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, December 18, 2000 7:15 AM Subject: Reg. SQL Loader..

hi all,

We have a production db. (oracle 7.2 on unix) - Source. We r planning to have a seperate db. for another application - Destination(oracle 8 on NT).

Source & Destination r in two different locations.

Periodically, some of the table data (say, data from few cols. of some 4 or 5 tables) has to be dumped in the NT db.

We r planning to do it by SQL Loader. It should be of automated activity as well as efficient.

Can anyone suggest me with examples (preferably with shell scripts) for doing the same.

Thanx,
Arul.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Arul kumar
INET: rakumar_at_mahindrabt.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 18 2000 - 06:19:32 CST