Oracle Snapshot

From: enigma <mabounajm_at_gmail.com>
Date: 8 Nov 2006 03:27:55 -0800
Message-ID: <1162985275.056327.259900@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 Received on Wed Nov 08 2006 - 05:27:55 CST