Database DataWarehousing (MOSC)

MOSC Banner

M views are getting invalid whenever its selected from

edited Feb 12, 2010 2:36AM in Database DataWarehousing (MOSC) 7 commentsAnswered
 Hello All,

I have a M-view with defination as :

CREATE MATERIALIZED VIEW MV_HESA_POP_DETAILS MATERIALIZED VIEW MV_HESA_POP_DETAILS

BUILD IMMEDIATE

REFRESH FORCE ON DEMAND

WITH PRIMARY KEY

AS

REFRESH FORCE ON DEMAND

WITH PRIMARY KEY

AS

WITH PRIMARY KEY

AS

AS

SELECT scj.scj_stuc,scj.scj_ayrc,scj.scj_code,scj.scj_hsin,scj.scj_estc,

scj.scj_sprc,scj.scj_qenc,sce.sce_scjc,sce.sce_ayrc,sce.sce_crsc,sce.sce_prgc,sce.sce_rouc, .scj_sprc,scj.scj_qenc,sce.sce_scjc,sce.sce_ayrc,sce.sce_crsc

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center