Re: Oracle Snapshot

So after being able to create a 'working' snapshot, i became curious to know more about commit.

Why is it that when i insert into the master table, I can see my results (before doing the commit), but the snapshot can't.. Put in another way, why is the date available to my session before it is available to everyone?

just for convenience? so that i see what my statements produce? or is there another technical reason i'm unaware of?

Thanks again!

Mazen

What's in a namespace wrote:
> Grinn ;-)
> You're not the first at will definitely not be the last.....
>
>
> "enigma" <mabounajm_at_gmail.com> schreef in bericht
> news:1163004919.180586.114160_at_e3g2000cwe.googlegroups.com...
> > 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 Thu Nov 09 2006 - 03:36:31 CST