Re: Oracle database links

Mark Heiple wrote:
>
> I can't get the database links to work. Just how do you create a database
> link?
> ... some extracted information ...
> I've tried CREAT PUBLIC DATABASE LINK LINK_TO_BACKUP USING
> 'MYDB_ON_BACKUP' from the PRIMARY machine while logged into the database
> MYDB_ON_PRIMARY.
>

Database links usually contain the username and password needed to connect to the remote database.

	CREATE DATABASE LINK LINK_T0_BACKUP
	   CONNECT TO username IDENTIFIED BY password
	   USING 'MYDB_ON_BACKUP';

If you don't specify the username and password in the link, Oracle uses the username and password that you used to log onto the local database when trying to make the remote connection.

I hope this helps.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com