OraFAQ Forum: Performance Tuning » How to Refresh a Materialized view Data.

Home » RDBMS Server » Performance Tuning » How to Refresh a Materialized view Data. (Oracle 10g, Windows 7 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Refresh a Materialized view Data. [message #586962]

Wed, 12 June 2013 01:29

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;

Code: [Select all] [Show/ hide]

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

Report message to a moderator