Oracle Error ORA-12023: missing index on materialized view “string”.”string”

Oracle Error Message

ORA-12023: missing index on materialized view “string”.”string”

Reason for the Error

The specified ROWID materialized view did not have the required index on the ROWID column of its underlying table.

Solution

Drop and recreate the materialized view.