database link

[debopom]

could anyone please tell me the steps in creating a database lonk ie there is a remote database and i would like to create a link in the local database server ...also what does the client needs to do once the lonk has been created

[irehman]

create database link TEST
connect to scott identified by tiger
using 'MYTEST';

to run the query
select * form emp@test;

for second part of your question
page 520 of Oracle8 Complete Reference.....

[Edited by irehman on 07-29-2002 at 01:28 PM]

[marist89]

I suggest you look at:
http://otn.oracle.com/docs/products/...elem.htm#27766
http://otn.oracle.com/docs/products/...ntro.htm#15199

and post more specific questions.