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 Wed Nov 08 2006 - 14:59:54 CST
