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-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


PCC-02336: host variable expression has invalid type

1 Answers  


ORA-02358: internal error fetching attribute string

1 Answers  


ORA-16515: no rcv channel

1 Answers  


KUP-04044: error positioning file string

1 Answers  






PLS-00592: the type of a object table must be an object type

1 Answers  


ORA-23411: materialized view "string"."string" is not in refresh group "string"."string"

1 Answers  


ORA-01117: adding file 'string' with illegal block size: string; limit is string

1 Answers  


ORA-33082: (XSAGDNGL41) In AGGMAP workspace object, the non-dimensioned valueset workspace object must have a parent QDR in its VALUESET statement over the VALUESET's base dimension.

1 Answers  


LPX-00314: an internal failure occurred

1 Answers  


LSX-00212: value "~1s" whose total digits exceeds ~2d

1 Answers  


ORA-28301: Domain Policy hasn't been registered for SSL authentication.

1 Answers  


Categories