| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent: Clarifications in data transfer...
What about using snapshots ????
that way, you will not need to look after any sqnet considerations or
else.......
because snapshot metodology involves triggers, snapshots logs..etc...etc...
Maybe snapshots is not applicable to your implementation...
>
> 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).
Received on Tue May 16 2000 - 12:11:30 CDT
 |
 |