Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem on Re-Replication of simple snapshot!
I might be missing something obvious here, but the recreate script you mention
just drops the snapshots. Where are the recreate steps?
Pete
Yeung Man wrote:
> 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
--
Regards
Pete
Received on Fri Jul 30 1999 - 10:51:47 CDT