Replication with Oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Replication with Oracle 8i

  1. #1
    Join Date
    Sep 2002
    Posts
    2
    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


  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    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.

    siva prakash
    DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width