enigma wrote:
> 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?
>
- Please do not top post in this group. Scroll to the bottom
to reply.
- Because until there is a committed transaction ... for purposes of a
materialized view ... nothing has happened. If you want the other
behaviour than you just want a regular view.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 09 2006 - 10:30:41 CST
