Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem on Re-Replication of simple snapshot!

Problem on Re-Replication of simple snapshot!

From: Yeung Man <yngm_at_chowsangsang.com>
Date: Fri, 30 Jul 1999 10:11:49 +0800
Message-ID: <7nr1ne$du0$1@news.hk.linkage.net>


Hi,

    We use replication manager creating simple snapshot in our client site. Everything is fine if we don't change the structure of the tables when we recreate the snapshot. However, if we change the structure of table and recreate the simple snapshot and snapshot refresh group. Then, when we refresh, follow error occur:

    begin

          dbms_refresh.refresh(name => '"SYSPOS"."SYSPOS"');     end;

    /*****

    ORA-12008: error in snapshot refresh path
    ORA-00904: invalid column name
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 587
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 644
    ORA-06512: at "SYS.DBMS_IREFRESH", line 561
    ORA-06512: at "SYS.DBMS_REFRESH", line 207
    ORA-06512: at line 2

    *****/

    The procedures to recreate snapshot are

  1. Delete snapshot from refresh group at client site.
  2. Drop snapshot by sql+ at client site.
  3. Drop snapshot log at master site.

    We try to repeat the procedure manually; however, same error occur.

    Do anyone know what happen?

    TIA. Man Received on Thu Jul 29 1999 - 21:11:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US