Re: - NEEDS_COMPILE Problem

From: jacquesh <jhullu_at_gmail.com>
Date: 20 Nov 2006 02:40:12 -0800
Message-ID: <1164019212.805080.204330@f16g2000cwb.googlegroups.com>

>> DDL
CREATE MATERIALIZED VIEW MV_00087_BRANCARD NOCACHE NOPARALLEL BUILD IMMEDIATE
USING INDEX TABLESPACE BRANCA PCTFREE 0
REFRESH START with sysdate NEXT sysdate+1/1440 FAST WITH PRIMARY KEY
ENABLE QUERY REWRITE AS SELECT * FROM brancard WHERE no_hop='00087';

No error message... only the field compile_state in 'all_mview' switch to 'NEEDS_COMPILE' ??
nothing other table or view are modified ; only new rows in table 'brancard'.

problem : the refresh failed.

if i try :: "alter materialized view MV_00087_BRANCARD compile" it's OK.

why ?

>> version Oracle 8.1.7.4

Thanks for your help. Received on Mon Nov 20 2006 - 04:40:12 CST