ORA-12057: materialized view "string"."string" is INVALID
and must complete refresh
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 |
TNS-01407: Status: string Total handlers: string Relevant handlers: string
ORA-09717: osnsui: maximum number of user interrupt handlers exceeded.
ORA-24122: invalid block range specification
NID-00430: Database is ready to be open or shut down.
TNS-12552: TNS:operation was interrupted
QSM-02133: agg(expr) requires correspondng MIN(expr) function
TNS-00238: Pump number @: string:
ORA-01319: Invalid Logminer session attribute
NNL-00225: Currently managing name server "string"
QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher
DRG-10501: invalid stopword: string
ORA-24031: invalid value, string should be non-NULL