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;


2 comments:

Anonymous said...

I needed a quick example of the usage of dblinks, and this provided just what I needed.

Thanks!

peah @ peps said...

No problem..:)