Sunday, February 21, 2010

Steps for creating the database links

1) Connect as testuser/**** user into database abc


SQL>conn testuser/****@abc

2) Create database link with the same name as global_name of xyz database .

SQL> create database link xyz.testdomain.com connect to testdblink identified by **** using ‘xyz’;

3) Verify the database link works

SQL > select * from global_names@xyz.testdomain.com

No comments: