Re: A Snapshot Question.

I've always dropped recreated the snapshot. creating a snapshot generates a table, SNAP$_My_table, which has the * columns when snap was originally created.

In article <3848a118.3037387_at_172.16.7.5>,   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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 13 1999 - 07:28:36 CST