Oracle DB link [message #55381] |
Tue, 21 January 2003 23:14 |
Haritha
Messages: 1 Registered: January 2003
|
Junior Member |
|
|
Hi All,
I created a db link using the follwing command:
CREATE DATABASE LINK mydblink CONNECT TO userA IDENTIFIED BY userA USING 'xxx';
When I was trying to access the userA table using the followin command
select * from table_name@mydblink.us.acme.com;
but it is giving
ERROR at line 1:
ORA-02019: connection description for remote database not found.
Can any body help me.
|
|
|
|
Re: Oracle DB link [message #55425 is a reply to message #55381] |
Thu, 23 January 2003 13:14 |
Siva Ram
Messages: 22 Registered: November 2001
|
Junior Member |
|
|
Hi
There are 3 types of links i.e., Private, Public and Gloabl.
To create a privaye database link, u need to have create databas link privilege, check by issuing the following st:
Select privilege from role_sys_privs where privilege in ('CREATE DATABASE LINK','CREATE PUBLIC DATABASE LINK');
If I remember well there should be a script for this, by default. Anyhow, after that, issue as
CREATE DATABASE LINK EMPLOYEE.GAZELLE.COM; (this creates a private link using the global database name to the remote EMPLOYEE database) and uses the connected username/password, that is if u r connected as siva/ram, the link establishes a connection to the remote database as siva/ram.
Hope it makes some sense and also check the tnsnames.ora, listener.ora files.
Thank you
Siva Ram
|
|
|
|