Oracle database error code ORA-12060 – shape of prebuilt table does not match definition query

Oracle Database Error Code ORA-12060 Description :
shape of prebuilt table does not match definition query
Error 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.

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


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»