How to use database link? Can i help me?

[Kevin Tran]

Dear All !

Ex : I have 2 server as NT1,NT2,
mydb1 on NT1, mydb2 on NT2.
I would like to create database link.
Can i help me?

Please send e-mail to me (carotonline@yahoo.co.uk)

Thank you very much for your help

Best regards

Carot

 

[AlienZzzz]

-- Create database link
/*You on DB2*/
create database link mydb1
connect to USER_NAME identified by USER_PASS
using 'mydb1_ORA_NAME';
--Syn--
create public synonym rUser_Tables for User_Tables@mydb1;
--Sel--
select * from rUser_Tables
------
this is select all user tables from db1
and You can use any DML operand - update insert delete .... !