Replication with Oracle 8i

[Faber]

I have two database and I want the replication of one to another.

One is named HAMACA and the other one is DES

HAMACA has a dblink called DES.OTEPI connected to DB DES
DES has a dblink called LABO connected to DB HAMACA

The HAMACA has a table called CLASIFICACION_EMPLEO should replicate in DB DES

I have created a snapshot log to CLASIFICACION_EMPLEO table

Now to create in the DD DES the snapshot of the CLASIFICACION_EMPLEO table I use the following sentence:

create snapshot clasificacion_empleo
refresh fast
with primary key
start with sysdate
next (sysdate + (1 / 1440))
for update as
select * from clasificacion_empleo@labo;

But I read the following error

The following error has occurred:

ORA-12014: table 'CLASIFICACION_EMPLEO' does not contain a primary key constraint

This type of message makes me suppose that HAMACA's CLASIFICACION EMPLEO table does not have a primary key which isn't true as it does and it is ENABLE.

Now if I want to execute the next sentence:
select * from clasificacion_empleo@labo;

It works and I get back the data, which means that the dblink is operating.

When I try to insert a duplicated record in HAMACA's CLASIFICACION EMPLEO table, the primary key does not allow to do this, this means to me that the primary key is functioning.

Hope you can assist me

Thanks

[prakashs43]

found this note in metalink

symptom: ORA-12014: table '%s' does not contain a primary key constraint
symptom: Database link has been created correctly
cause: If the snapshot definition query of a CREATE SNAPSHOT DDL
referenced a remote table, whose owner is not explicitly
specified, an ORA-12014 was raised if the owner of the
snapshot was different than the username specified in the
database link that was used to access the remote table.


The error is VERY misleading. The table you are creating a snapshot
from does have a primary key constraint and your snapshot log is recording
WITH PRIMARY KEY.