Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create DB link without tns

BagiyaJan 23 2011 — edited Jan 23 2011

Dear All

Could you pls tell me there is any way to create DB link without using tnsnames.ora ? Can I create like below

create database link PRODUCTDB
connect to scott
identified by tiger
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.1.6)(Port=1908)))(CONNECT_DATA=(SERVICE_NAME=ORCL)))';

Note : I dont have to privilages to modify tnsnames.ora.

Thanking you

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2011

Added on Jan 23 2011

#general-database-discussions

5 comments

22,600 views