Re: Urgent: Clarifications in data transfer...

Hi Rajagopal,Claudia,Jhonson,

        Thanks for all your views. It'll be of great help to me in deciding the method.

NS.

On Tue, 16 May 2000, Rajagopal Venkataramany wrote:

> 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
>

NS.

			SENTHIL KUMAR N
			SYSTEMS ENGINEER
			TATA INFOTECH LIMITED
			BANGALORE 560038
			INDIA.
                        email:senthilkumar.nallathambi_at_tatainfotech.com
                        phone:+91(080) 5284681 extn: 251.
			fax:+91(080) 5284491.