Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Snapshot
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.orgReceived on Wed Nov 08 2006 - 11:04:26 CST
![]() |
![]() |