-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|