 | |
#1
 
| |||
| |||
|
Oracle Snapshot -
11-08-2006
, 05:27 AM
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
"enigma" <mabounajm (AT) gmail (DOT) com> schreef in bericht news:1162985275.056327.259900 (AT) f16g2000cwb (DOT) 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? |
#4
| |||
| |||
|
|
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 |
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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#5
| |||
| |||
|
|
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@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |
Shakespeare
(ns.oracle.com is still down...;-)
#6
| |||
| |||
|
|
lol No! Thanks alot That was it. What's in a namespace wrote: "enigma" <mabounajm (AT) gmail (DOT) com> schreef in bericht news:1162985275.056327.259900 (AT) f16g2000cwb (DOT) 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? |
#7
| |||
| |||
|
|
Grinn ;-) You're not the first at will definitely not be the last..... "enigma" <mabounajm (AT) gmail (DOT) com> schreef in bericht news:1163004919.180586.114160 (AT) e3g2000cwe (DOT) googlegroups.com... lol No! Thanks alot That was it. What's in a namespace wrote: "enigma" <mabounajm (AT) gmail (DOT) com> schreef in bericht news:1162985275.056327.259900 (AT) f16g2000cwb (DOT) 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? |
#8
| |||
| |||
|
|
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 (DOT) com> schreef in bericht news:1163004919.180586.114160 (AT) e3g2000cwe (DOT) googlegroups.com... lol No! Thanks alot That was it. What's in a namespace wrote: "enigma" <mabounajm (AT) gmail (DOT) com> schreef in bericht news:1162985275.056327.259900 (AT) f16g2000cwb (DOT) 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? |
to reply.
2. 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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.