Home » SQL & PL/SQL » SQL & PL/SQL » how to create a database link
how to create a database link [message #36190] Fri, 09 November 2001 00:31 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: COLUMN INTO ROWS AND VICE VERSA
Next Topic: how to create cursor with bind variables
Goto Forum:
  


Current Time: Thu Mar 28 03:20:56 CDT 2024