Re: A Snapshot Question.

The sql used for the snapshot is not being interpreted each time it is run. I believe that the system has already parsed the snapshot and the column ID for each of the columns in '*' at the time the snapshot is made so whenever you change the columns you must recreate your snapshots.

Regards
-R

NetComrade wrote:

> 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
Received on Tue Jan 04 2000 - 19:54:46 CST