Easy connect database links

Saves modifying tnsnames.ora:

create database link mylink connect to myuser identified by mypassword using '//myserver/mydatabase' ;

Note that passwords are case sensitive from 11g. This means 10g->11g links need uppercase passwords.

November 16, 2010

Leave a Reply

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