Friday, August 13, 2010

Example of how to create database link

CREATE DATABASE LINK alexdb
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.31.2.131)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ALEXDB)
)
)';

No comments: