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:
Post Comments (Atom)
2 comments:
I needed a quick example of the usage of dblinks, and this provided just what I needed.
Thanks!
No problem..:)
Post a Comment