[vue Materialiser] - Needs_compile

**jacquesh** · 16/11/2006, 12h42

bonjour

je souhaiterai avoir une explication sur la signification d'un champs dans ALL_MVIEWS

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

select MVIEW_NAME, LAST_REFRESH_TYPE, LAST_REFRESH_DATE, AFTER_FAST_REFRESH, COMPILE_STATE from all_mviews where OWNER='MOI' ;

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
 
MVIEW_NAME                     LAST_REF LAST_REF AFTER_FAS COMPILE_STATE
------------------------------ -------- -------- --------- -------------
POUGUAUHTY                     COMPLETE 16/11/06 NA        VALID
VM_BRANCARD                    COMPLETE 16/11/06 NA        NEEDS_COMPILE
VUE_00073_ETA                  COMPLETE 16/11/06 UNDEFINED VALID
VUE_00073_PASSINT              COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00073_PDT                  COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00073_PLTTECH              COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00073_SER                  COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00073_UAD                  COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00073_UFP                  COMPLETE 16/11/06 UNDEFINED VALID
VUE_00073_UHPDT                COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00087_ETA                  COMPLETE 16/11/06 UNDEFINED VALID
 
MVIEW_NAME                     LAST_REF LAST_REF AFTER_FAS COMPILE_STATE
------------------------------ -------- -------- --------- -------------
VUE_00087_PASSINT              COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00087_PDT                  COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00087_PLTTECH              COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00087_SER                  COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00087_UAD                  COMPLETE 16/11/06 UNDEFINED ERROR
VUE_00087_UFP                  COMPLETE 16/11/06 UNDEFINED VALID
VUE_00087_UHPDT                COMPLETE 16/11/06 UNDEFINED ERROR
VUE_99999_PASSINT              COMPLETE 16/11/06 UNDEFINED ERROR
VUE_99999_PDT                  COMPLETE 16/11/06 UNDEFINED ERROR
VUE_99999_PLTTECH              COMPLETE 16/11/06 UNDEFINED ERROR
VUE_99999_SER                  COMPLETE 16/11/06 UNDEFINED ERROR
 
MVIEW_NAME                     LAST_REF LAST_REF AFTER_FAS COMPILE_STATE
------------------------------ -------- -------- --------- -------------
VUE_99999_UAD                  COMPLETE 16/11/06 UNDEFINED ERROR
VUE_99999_UFP                  COMPLETE 16/11/06 UNDEFINED VALID
VUE_99999_UHPDT                COMPLETE 16/11/06 UNDEFINED ERROR
 
25 rows selected.
 
SQL>