OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » dblink

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dblink [message #39573]

Tue, 23 July 2002 22:30

saravanan
Messages: 70
Registered: October 2000

Member

hai

please let me know how to create a database link to access a database in another schema.

an example with explanation would be really helpful.

thanks and regards.

Report message to a moderator

Re: dblink [message #39578 is a reply to message #39573]

Wed, 24 July 2002 01:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

CREATE DATABASE LINK sales
CONNECT TO hr IDENTIFIED BY hr
USING 'sales';

above, a dblink named sales is created.it connects to the sales databases, to the user Hr.
and you can issue select statements and DML as

SELECT * FROM employees@sales;

Report message to a moderator

Re: dblink [message #39591 is a reply to message #39578]

Wed, 24 July 2002 22:32

saravanan
Messages: 70
Registered: October 2000

Member

thanku mahesh

Report message to a moderator

Previous Topic:	urgent
Next Topic:	Order using the rownum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 05:03:09 CDT 2024