ORA-00904 - ORA-12008 - “DV$”.”SE0″: invalid identifier
Oracle : < 10.2
OS : Tous ?
Symptomes :
exec dbms_mview.refresh(’majv4333601′,’F');ORA-12008: error in materialized view refresh path
ORA-00904: “DV$”.”SE0″: invalid identifier
ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 794
ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 851
ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 832
ORA-06512: at line 1
Solution :
C’est plutôt simple : Bug 4333601 - ORA-904 during MVIEW fast refresh
Vous pouvez tenter de modifier votre code SQL, surtout celui de la vue. sinon il faut passer sur les versions suivantes :
- 9.2.0.8 (Server Patch Set)
- 10.1.0.5 (Server Patch Set)
- 10.2.0.1 (Base Release)
David.
Post a comment