Accessing another Database in SQL

[amerbaig]

Can I access another data base when I am working in another database. LIke

Select * from dbmgt/Pass@sales.purch

 

[rcurva]

Of course you can, that is if you have a database link on that DB.

As a DBA create a dblink in your DB...

CREATE PUBLIC DATABASE LINK myotherdb.link
CONNECT TO username IDENTIFIED BY password
USING 'other_db';

Make sure that your DB server can connect to your 'other' DB.

Then from your sqlplus:

select *
from TABLE1@myotherdb.link;