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)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment