Home » RDBMS Server » Performance Tuning » How to Refresh a Materialized view Data. (Oracle 10g, Windows 7 64 bit)
How to Refresh a Materialized view Data. [message #586962] Wed, 12 June 2013 01:29 Go to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Hi,

I have created a materialized view and also a normal View,
which has 3 tables used in both the views, when inserted
new records it reflects in a normal view but when i select
the materilazed view i cant see the updated data.

here is the materialized view i created;

CREATE MATERIALIZED VIEW pct_sales_materialized
BUILD IMMEDIATE REFRESH ON DEMAND
ENABLE QUERY REWRITE 
AS
SELECT A.DEP_NAME,B.EMP_ID,C.EMP_NAME
FROM department_head A,department_child B,emp_detail C
WHERE A.DEP_ID = B.DEP_ID
AND B.EMP_ID = C.EMP_ID


Stalin
Re: How to Refresh a Materialized view Data. [message #586967 is a reply to message #586962] Wed, 12 June 2013 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
REFRESH ON DEMAND


If you want it refreshes then ask it.
Have a look at DBMS_REFRESH and DBMS_SNAPSHOT packages.

Regards
Michel
Re: How to Refresh a Materialized view Data. [message #587001 is a reply to message #586967] Wed, 12 June 2013 06:48 Go to previous message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
thank you for the reply i tried that.
Previous Topic: Memory Allocation in 11 G
Next Topic: Performance tuning made easy
Goto Forum:
  


Current Time: Thu Mar 28 06:54:21 CDT 2024