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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00423: ORDER BY item must be the number of a SELECT-list expression

1 Answers  


NNO-00316: statistic counter reset disabled

1 Answers  


RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped

1 Answers  


ORA-26003: parallel load not supported for index-organized table string.

1 Answers  


PCC-02144: CMD-LINE: Blank characters are not allowed on either side of an equal sign (=)

1 Answers  






ORA-13837: invalid HASH_VALUE

1 Answers  


DRG-12430: mandatory argument missing: string

1 Answers  


ORA-13454: GeoRaster metadata is invalid

1 Answers  


ORA-36774: (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

1 Answers  


O2F-00328: Illegal INITFUNC name

1 Answers  


ORA-00202: controlfile: 'string'

1 Answers  


ORA-38732: Expected file size string does not match string.

1 Answers  


Categories