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;
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;
Comments
Post a Comment