Monday, January 5, 2009

Creating a database link (DB link )

Syntax:
Creating a database link

create database link DB_Link connect to "Username" identified by "Password"using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=HOsT string)(Port =
Port number))(CONNECT_DATA=(SID = service ID)))';

creating a synonym :
create or replace synonym synonym1for schmea. synonym1 @DB_Link;

Creating a table:
create table table1 as (select * from table1@db_link)

No comments: