Sunday 26 July 2015

Database Links Queries


 Database Links Queries:

 **************************************************************
Name of Database
************************************************************** 

 SQL> select name from v$database;

**************************************************************
List of DB links
**************************************************************

 set pagesize 100
set lines 200
col host for a20
col db_link for a30
select * from dba_db_links order by created;

**************************************************************
 Using DB Link   --- check if it works correctly
**************************************************************  
 

select 'X' from dual@Name_of_dblink;
selet * from dual@Name_of_dblink;


**************************************************************
Creating DB links
**************************************************************  
CREATE DATABASE LINK "Name_of_dblink" CONNECT TO APPS IDENTIFIED BY <PWD> USING 'target_db';


1 comment: