Re: A Snapshot Question.

I believe you have to recreate your snapshot.

On 11 Dec 1999 06:44:27 GMT, violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:

>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

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email