A Snapshot Question.

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 11 Dec 1999 06:44:27 GMT
Message-ID: <3848a118.3037387@172.16.7.5>

Hello all,

If I do the next steps:

1.Loggon Master Site as scott / tiger

   CREATE SNAPSHOT LOG ON emp WITH PRIMARY KEY;

2.Loggon Snapshot Site as scott /t tiger,too.

   CREATE DATABASE LINK master CONNECT BY scott IDENTIFIED tiger USING 'master';

   CREATE SNAPSHOT emp REFRESH FAST AS SELECT * FROM emp_at_master;

   BEGIN

         dbms_refresh.make('REFGRP' , 'EMP' , SYSDATE , 'SYSDATE + 1 /24');
         commit;

   END;   This works at my Snapshot Site with EMP Snapshot    when INSERT,UPDATE,DELETE rows in Master Site.

3.But if now I have to modify EMP at the Master Site:

   ALTER TABLE EMP ADD address VARCHAR2(100);

   UPDATE EMP SET address = 'Live in somewhere' WHERE EMPNO = 7566;

• But the Snapshot site,EMP snapshot doesn't have address column. Do I need to drop and create snapshot log and snapshot again? Or is there other way?

Thank you for any helps.

Violin.
violin.hsiao_at_mail.pouchen.com.tw Received on Sat Dec 11 1999 - 00:44:27 CST