Send your questions to appsdbauniverse@gmail.com

Friday, March 18, 2016

Do you know how to create a database link without full TNS connect string starting 11g ?


SQL> CREATE DATABASE LINK test
  2  CONNECT TO remoteschema IDENTIFIED BY password
  3  USING 'remoteserver:port/VIS1';
  
Database link created.

========================================================================

No comments:

Post a Comment