Home » SQL & PL/SQL » SQL & PL/SQL » Materilized View Refresh (Oracle 9i)
Materilized View Refresh [message #296944] Tue, 29 January 2008 10:23 Go to next message
balamurugan.murthy
Messages: 21
Registered: October 2007
Junior Member
Hi ,

When i tried to refresh the materialized view and try to access the data from another session, i was unable to get any data from the
materialized view ( got an empty result set).

Will the data be delted completely when the Materialized view is refreshed ? The Materialized view description goes like this

CREATE MATERIALIZED VIEW test_mv
TABLESPACE testspace
NOCACHE
LOGGING
NOPARALLEL
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
WITH PRIMARY KEY


Could any one please calrify on this and suggest any links to study more on this topic ?
Re: Materilized View Refresh [message #296952 is a reply to message #296944] Tue, 29 January 2008 11:03 Go to previous message
ramanajv1968
Messages: 168
Registered: December 2005
Location: HYDERABAD
Senior Member
This is link might be useful to you

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96520/mv.htm#38255
Previous Topic: Oracle Bug - PLSQL variable names
Next Topic: Display column values in the header
Goto Forum:
  


Current Time: Sun Dec 11 00:37:53 CST 2016

Total time taken to generate the page: 0.09131 seconds