Pedro,

Please read the documentation located at http://tahiti.oracle.com

1. Concepts
2. PL/SQL user's guide
3. Replication


-----------------
Ron Reidy
Senior DBA
Array BioPharma, Inc.


-----Original Message-----
From: Pedro Martins [mailto:producao@(protected)]
Sent: Wednesday, August 11, 2004 11:02 AM
To: suse-oracle@(protected)
Subject: [suse-oracle] Oracle 8i Database Link Help


Hi

I'm new to Oracle, and I'm using Oracle 8i.
I need to to the following: I have two distinct databases (DB1 and DB2) on different locations. The idea is to update a table XPTO in DB1 everytime, that same table is updated in DB2.
I checked some documentation and what I needed was:

- Create a DB link between DB1 and DB2
- Create a snapshot of each table XPTO in DB1 and DB2
- Create a trigger

Can you explain me step by step, how to create a database link ? What are the modifications needed on tnsnames.ora and listener.ora

I would appreciate an answer
Cheers
Pedro


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting