lol No!
Thanks alot
That was it.
What's in a namespace wrote:
> "enigma" <mabounajm_at_gmail.com> schreef in bericht
> news:1162985275.056327.259900_at_f16g2000cwb.googlegroups.com...
> > Hi,
> >
> > I'm trying to test the oracle snapshot but failing to do so. I have a
> > test database with a table called RT_MANUFACTURER. I created a
> > materialized view using:
> >
> > CREATE MATERIALIZED VIEW LOG ON RT_MANUFACTURER;
> >
> > Then i tried to create a snapshot of that table using:
> >
> > create materialized view snpp refresh fast start with sysdate
> > next sysdate + 1/14400 as select * from RT_MANUFACTURER;
> >
> > to check if it worked, i entered this element in my table:
> >
> > INSERT INTO RT_MANUFACTURER (ID,NAME) VALUES (8888, 'please work');
> >
> > waited alot of time, then tried
> >
> > select * from snpp where ID = 8888;
> > nothing returns...
> >
> > could anyone tell me what else should i do?
> >
> > Thanks
> >
>
> Did you commit?
Received on Wed Nov 08 2006 - 10:55:19 CST
