Re: Urgent: Clarifications in data transfer...

Hi Senthil,

  My views are :

  The Flat file method would be the best due to the following reasons :

1. We do not have to have the databases running at the same time for the sync up to happen. We do not run the risk of trying to connect to the remote db when it is undergoing a maintenance run or is down for some reasons.
2. The extraction could be done in the source db in a lean time.
3. The file can be compressed, transmitted and uncompressed at the destination reducing the overload on the network even if the file size increases in future.
4. SQL-loader is lot more faster and good at handling batch data loads.

Regards
Rajagopal Venkataramany

----Original Message Follows----
From: SENTHILKUMAR NALLATHAMBI <senthilkumar.nallathambi_at_tatainfotech.com> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Urgent: Clarifications in data transfer... Date: Tue, 16 May 2000 07:05:18 -0800

Hi gurus,

I have two databases A and B and need to transfer data between them. A and B are located in geographically different regions. The link between them is either a leased or a dialup over a VSN line. I have same table structures in both the database.   Average load would be 500 - 1000 records (600 bytes/record) per day. The peak load will be 20,000 (600 bytes/record) records/day .

I would like to know the efficient mode of data transfer. I will be transferring record in batch mode.

I thought of two alternatives:

1.Creating a dblink and transferring the information between the database. 2.Use SQL loader, create flat files and transfer the flat file.

I also like to know the main issues that i must consider while doing on a dblink and the exceptions that i need to handle.

Any help will be of great use,

NS.

--
Author: SENTHILKUMAR NALLATHAMBI
   INET: senthilkumar.nallathambi_at_tatainfotech.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).

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com