RE: Urgent: Clarifications in data transfer...

Hi Claudia,

        We had considered the Oracle advanced replication and we are using the same for some tables wherein the amount of data transfered over the sqnet is small and where there are only rare changes to these ,essentially maseter, tables. But for the some other tables the data transfered will be more and if replication is used will cost a lot of overheads also. Also for these tables replication is not applicable because of the processing logic on the datas of the tables.

        So we are looking for either a dblink operation wherein we have to consider all the distributed transaction issues or a typical spool-ftp-load method.

        According to me both methods are almost same on the network traffic. But different in the methods of handling. In a spool and load method, we need not consider the distributed transaction issues. But it needs manual intervention. But in case of dblink transfer it can be automated easily, but the dblink issues have to be considered.

        So i need to take a decision whether to use dblink or spool-load method. Any help in this respect will be of great use.         

NS.

On Tue, 16 May 2000, Claudio Roca wrote:

> 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...
>
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, May 16, 2000 12:05 PM
>
>
> >
> > 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).
>
> --
> Author: Claudio Roca
> INET: croca_at_afip.gov.ar
>
> 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
Received on Wed May 17 2000 - 03:03:01 CDT