Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Snapshot
"DA Morgan" <damorgan_at_psoug.org> schreef in bericht
news:1163005466.280658_at_bubbleator.drizzle.com...
> enigma wrote:
>> 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
>>
>
> Look at the demos in Morgan's Library at www.psoug.org under
> Materialized Views. A little cutting and pasting will give you working
> demos you can then modify for your use.
> --
> 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
Or a simple commit will do too.....
Shakespeare
(ns.oracle.com is still down...;-)
Received on Wed Nov 08 2006 - 14:58:50 CST