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

ORA-24812: character set conversion to or from UCS2 failed

1 Answers  


LCD-00219: nested include file [string] is too large

1 Answers  


IMG-00511: %s

1 Answers  


NNO-00054: invalid domain name "string"

1 Answers  


ORA-01336: specified dictionary file cannot be opened

1 Answers  






PCC-01202: Identifier "string" truncated to 31 characters

1 Answers  


NID-00338: Control Files in database:

1 Answers  


ORA-09771: osnmwrtbrkmsg: bad return code from msg_send.

1 Answers  


ORA-32164: Method called on Invalid Connection type

1 Answers  


ORA-28157: Proxy user 'string' forbidden to set role 'string' for client 'string'

1 Answers  


EXP-00031: Arraysize not in valid range. Using arraysize=number

1 Answers  


ORA-13344: an arcpolygon geometry has fewer than five coordinates

1 Answers  


Categories