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.