Thursday, October 11, 2012

Materialized View Creation 

DROP MATERIALIZED VIEW apps.XX_TEST_V_MV
/ 
CREATE MATERIALIZED VIEW apps.XX_TEST_V_MV
NOLOGGING
PARALLEL
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
ENABLE QUERY REWRITE
AS
select * from xx_emp
/ 

Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)