Showing posts with label ORA-12060: shape of prebuilt table does not match definition query. Show all posts
Showing posts with label ORA-12060: shape of prebuilt table does not match definition query. Show all posts

Thursday, 16 February 2012

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

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

Cause: 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.

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