Re: need help creating a database link

There are some complexities to consider if both db's have the same sid. Take a look at the GLOBAL_NAMES parameter in your init.ora file.

Gene Hubert
http://www.skillspoint.com - Where Smart People Buy Training!

On Mon, 05 Jun 2000 20:33:50 GMT, "Rob Freeman" <rfreeman_at_authentica.com> wrote:

>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
>
>
Received on Tue Jun 06 2000 - 00:00:00 CDT