how to create a database link [message #36190] |
Fri, 09 November 2001 00:31 |
prakash
Messages: 24 Registered: October 2001
|
Junior Member |
|
|
After successfully creating a database link;
select emp_id from employee@hello;
i get the error
Authorisation adapter initialisation failed;
can anybody help me out....
what is the remedy for that error;
thanks
prakash
----------------------------------------------------------------------
|
|
|
Re: how to create a database link [message #36208 is a reply to message #36190] |
Fri, 09 November 2001 10:37 |
Siva Ram
Messages: 22 Registered: November 2001
|
Junior Member |
|
|
Hi Prakash
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, u understood !!!
Thank you
Siva Ram
----------------------------------------------------------------------
|
|
|