Re: Urgent: Clarifications in data transfer...

May be you should take a look at Direct-load insert, depending on the version you are in.

Johnson

• Rajagopal Venkataramany <rajagopalvr_at_hotmail.com> 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----
  > Reply-To: ORACLE-L_at_fatcity.com
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > 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
  >
  > --
  > Author: Rajagopal Venkataramany
  > INET: rajagopalvr_at_hotmail.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).
  

  ---