Database Link accross two machine

[snaik_44]

How to create database link,
Say I have instance TST on Machine1 and CRP on Machine2

I want select tables from TST with sql session on Machine2 connected to CRP instances
Sanjay

[psrchaks]

CREATE DATABASE LINK
CONNECT TO identified by
USING . The entry for this service name should be there in the tnsnames.ora of your current server.

Hope this answers your question...Let me know if you still have doubts....

Cheers
Chakri

[armel]

1) tnsnames.ora must be updated

2) must grant create database link to user

3) just create database link with

Create database link "name" connect to "remoteuser"
identified by "remoteuserpass" using "remotedatabase".world

hope that will help

[rsuri]

while creating the database link you may also notice that there may be restrictions like your db_link Name should be same as the remote database's SID Name depending upon your Global_Names is set or not....

- Rajeev

[snaik_44]

I dont what I am doing wrong

I connected as system/manager on TST instance which has tnsnames.ora entry as connect string 'TST'

I created link using
QL> create public database link TST1 connect to apps identified by apps
2 using 'TST';

Database link created.

Now I created a table in apps schema say test

Then I connect another instance CRP which has connect CRP

I am trying accces above test tables
using

select count(*) from test@TST1

Not working
Thanks fro replies
Sanjay

[rsuri]

what is the error when you run --

select count(*) from test@TST1


As I said the problem may be in the db_link name...try following --

create public database link TST connect to apps identified by apps using 'TST';

Is the SID name also TST ?

- Rajeev

[snaik_44]

Thanks Guys
It works
Sanjay