need help creating a database link

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 Mon Jun 05 2000 - 00:00:00 CDT