Pages

Showing posts with label Database Link. Show all posts
Showing posts with label Database Link. Show all posts

Monday, October 25, 2010

Database Link 11G

With 11G some new features and some releated changes came in picture.
Password is case sensitive in 11g, and so is needed for all the db links.

So for creating a db link b/w 10g to 11g, keep in mind to plece the password in double quotes.

Like:

Saturday, August 28, 2010

DB Links

DB Links or Database Links are used to connect mainly one database to another. It may be used to point to same database in some cases.
The information related to DB Link can be found from "DBA_DB_LINKS".

The syntax for db links is
SQL> Create [PUBLIC] database link "<Link_name>"
        connect to <remote_dbuser> identified by <remoteuser_pasword>
        using '<host>';