Oracle Error ORA-12060: shape of prebuilt table does not match definition query

Oracle Error Message

ORA-12060: shape of prebuilt table does not match definition query

Reason for the Error

The number of columns or the type or the length semantics of a column in the prebuilt table did not match the materialized view definition query.

Solution

Reissue the SQL command using BUILD IMMEDIATE, BUILD DEFERRED, or ensure that the prebuilt table matches the materialized view definition query.