DBA_MVIEWS Shows COMPILATION_ERROR in COMPILE_STATUS Column
Last updated on APRIL 16, 2014
Applies to:Oracle Database - Standard Edition - Version 220.127.116.11 to 18.104.22.168 [Release 9.2 to 11.2]
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 9.2 to 11.2]
Information in this document applies to any platform.
The values of the COMPILE_STATUS column in DBA_MVIEWS are as follows:
The first two are normal behavior. The compile_status will be 'VALID' right after a refresh but before there is DML on the master table; it will be 'NEEDS_COMPILE' after there has been DML on the master table.
The status of 'COMPILATION_ERROR', however, is not expected. This note is intended for a general audience, as an initial starting point for beginning diagnosis of the 'COMPILATION_ERROR' status.
A materialized view (mview) refresh has occurred, and the COMPILE_STATUS in DBA_MVIEWS now shows as 'COMPILATION_ERROR'.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms