Showing posts with label Oracle 10g: DBLINK. Show all posts
Showing posts with label Oracle 10g: DBLINK. Show all posts
Saturday, January 19, 2008
Oracle 10g: DBLINK
/*Create database link
testlink: dblink name
sa: schema
EPLOG: the other database's name
*/
CREATE DATABASE LINK testlink CONNECT TO sa IDENTIFIED BY sa USING 'EPLOG';
/*How to call
WF_LOGFILE: name of the table
testlink: name of the created dblink
*/
SELECT * FROM WF_LOGFILE@testlink;
testlink: dblink name
sa: schema
EPLOG: the other database's name
*/
CREATE DATABASE LINK testlink CONNECT TO sa IDENTIFIED BY sa USING 'EPLOG';
/*How to call
WF_LOGFILE: name of the table
testlink: name of the created dblink
*/
SELECT * FROM WF_LOGFILE@testlink;
Subscribe to:
Posts (Atom)