EZConnect syntax eliminates the need for service name lookup in tnsnames.ora files when connecting to an Oracle Database across a TCP/IP network. In a previous post we have already demonstrated how to use this syntax to establish connection in SQL*Plus.
Now, we are going even further. You can use the same syntax for creating Database Links (assuming that you have a privilege to create database links in general).
CREATE DATABASE LINK dbl_test
CONNECT TO scott
IDENTIFIED BY tiger
Database link created.
See http://www.orafaq.com/wiki/EZCONNECT for more information on the syntax and prerequisites.
My Oracle Group on Facebook:
If you like this post, you may want to join my new Oracle group on Facebook: https://www.facebook.com/groups/sqlpatterns/
Would you like to read about many more tricks and puzzles?
For more tricks and cool techniques check my book “Oracle SQL Tricks and Workarounds” for instructions.