Oracle Solution for Error ora-12060

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

What triggered 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.

What should we do to fix it:

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