DB Link

Following query can be used to create a DB link from one oracle database to another..


CREATE PUBLIC DATABASE LINK <linkname>
CONNECT TO <username> IDENTIFIED BY <password>
USING '<hostname>'

Query as below to check about DB links...


SELECT NAME,HOST,USERID,PASSWORD FROM SYS.LINK$;

select owner,db_link,host from dba_db_links;