urgent plz guide me! [message #38185] |
Fri, 29 March 2002 04:49 |
siddhi
Messages: 1 Registered: March 2002
|
Junior Member |
|
|
Plz tell me the Pl/SQL code for creating a db link from the server db to client db.Actually i just want to connect serverdb to client db & update all records on the server which r deleted/added/updated on the client m/c.I am totally new to this concept so plz give a detailed reply.
Well is the foll. code correct:
Create db link link_name using servername;
Select all from table name @ link name;
/* pl/sql code for changing the status of the records which have been updated/inserted/ deleted.*/
I hope i get a reply soon.
Thanx a lot.
|
|
|
Re: urgent plz guide me! [message #38186 is a reply to message #38185] |
Fri, 29 March 2002 06:43 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
From the client:
1. create alias entry in tnsnames.ora for remote server.
2. create database link DBLINK connect to USER identified by PASSWORD using 'tns_alias';
3. Usage: update TABLE@dblink ...
|
|
|