Re: need help creating a database link

I believe you get this error when you have GLOBAL_NAMES=TRUE in your init.ora. This enforces that dblinks have the same name as ther database they are linking to. From the 8i docs

A database link should be given the same name as the global database name of the remote database it references. When you set the initialization parameter GLOBAL_NAMES to TRUE, Oracle ensures that the name of the database link is the same as the global database name of the remote database. See the Oracle8i Reference for more information about specifying the initialization parameter GLOBAL_NAMES.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Rob Freeman" <rfreeman_at_authentica.com> wrote in message
news:O8U_4.1160$Hs5.142580_at_dfiatx1-snr1.gtei.net...


> Goal:  To set up Oracle replication between two Oracle servers.  I have

 the


> syntax for an hourly snapshot of the master database, however, I can't get

> the database link to work.

>

> What I have done:

>

> On both machines I have the user pvmaster identified by donetsk.  Locally

 I


> can do:

>

> SQL>connect pvmaster/donetsk

> connected

>

> Remotely:

>

> SQL>connect pvmaster/donetsk_at_icicle

> connected

>

> I have granted "create database link" to the local pvmaster account.

>

> So I create the database link like this:

>

> SQL>create database link pvmaster

> 2  connect to pvmaster identified by donetsk

> using icicle;

>

> link created

>

> There is a table, pv_instance_data on the remote database, and it belongs

 to


> pvmaster.  I can log on remotely and select pv_key from pv_instance_data

 and


> view the contents of the pv_key column.

>

> however, when I try:

>

> SQL> select pv_key from pv_instance_data_at_pvmaster;

>

> I get the error:

>

> Error at line 1 database link PVMASTER connects to ORACLE

>

> Thanks for the help!

>

> Sincerely,

>

> Rob Freeman

> rfreeman_at_authentica.com

>

>