Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problem on Re-Replication of simple snapshot!
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
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