Recreate replication

From: Pavel Kahle <pavel.kahle_at_gecapital.com>
Date: 14 Feb 2002 00:34:52 -0800
Message-ID: <1340eac6.0202140034.67828a63_at_posting.google.com>

Hi,
I have problem with recreating simple replication on Oracle 8.1.7. Thanks for any help
Pavel Kahle

The scenario :

I have table in master DB with primary index over 2 (all) columns, with 1 Foreign key.
I create snapshot log with "create snapshot log on TableX ". On the client DB I create snapshot with :

        "create snapshot TableX
               refresh fast with primary key
               start with sysdate
               next   sysdate + 1/(24*60)
               as (select * from TableX_at_master);"

refresh is working well.
Steps to recreate repl.:
Master DB
 add column to tablex, change primary index over 3 (all) columns. Client DB
"drop snapshot Tablex"

Master DB
"drop snapshot log on Tablex;"
"create snapshot log on TableX with primary key;"
Client DB

        "create snapshot TableX
               refresh fast with primary key
               start with sysdate
               next   sysdate + 1/(24*60)
               as (select * from TableX_at_master);"

refresh fails with :

ORA-12008: error in snapshot refresh path
ORA-00904: invalid column name 
ORA-06512: on "SYS.DBMS_SNAPSHOT", line 610
ORA-06512: on "SYS.DBMS_SNAPSHOT", line 667
ORA-06512: on "SYS.DBMS_IREFRESH", line 577
ORA-06512: on "SYS.DBMS_REFRESH", line 211
ORA-06512: on line 1

Received on Thu Feb 14 2002 - 09:34:52 CET