How to create a database link in Oracle?

The syntax has been enhanced to remove the need to epscify a TNS service_name:

CREATE PUBLIC DATABASE LINK <Link_Name>  CONNECT TO <remote_username>
IDENTIFIED BY <PWD>
USING ”tns_service_name‘;

 

 

Hits: 1

0 thoughts on “How to create a database link in Oracle?

  1. Helpful info. Fortunate me I found your website unintentionally, and I’m stunned why this coincidence didn’t happened earlier! I bookmarked it.

Leave a Reply

Your email address will not be published. Required fields are marked *