Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-12057: materialized view "string"."string" is INVALID
and must complete refresh
- 1 Answers
- 3191 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The status of the materialized view was INVALID and
an attempt was made to fast refresh the materialized view.
Action: Perform a complete refresh of the materialized view.
Check the value of the STATUS column in dba_mviews,
all_mviews, or user_mviews to verify that the materialized
view is VALID after the complete refresh.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-19580: %s conversation not active
ORA-01231: cannot make read write - file string is offline
ORA-31092: invalid SQL name "string"
DRG-11613: URL store: connection refused to host specified by string
ORA-14131: enabled UNIQUE constraint exists on one of the tables
EXP-00078: Error exporting metadata for index string. Index creation will be skipped
ORA-09931: Unable to open ORACLE password file for reading
ORA-22339: cannot alter to not final since its attribute column is substitutable
ORA-16180: number processes specified for MAX_PARALLEL_SERVERS is too small
ORA-00226: operation disallowed while alternate controlfile open
ORA-30336: no child for specified JOIN KEY
QSM-02081: mv log does not have all necessary columns
Oracle Errors 
