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-00499: coercion into collection of records not supported

1 Answers  


ORA-12620: TNS:requested characteristic not available

1 Answers  


ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns

1 Answers  


PLS-00729: only widening of the collection element type is allowed

1 Answers  


RMAN-06020: connected to auxiliary database (not started)

1 Answers  






ORA-27413: repeat interval is too long

1 Answers  


DRG-50948: ABOUT clause required in the absence of a text index

1 Answers  


ORA-07449: sc: usnewlock failed.

1 Answers  


NID-00310: Control File string - reverted

1 Answers  


QSM-01048: join back level(s) not present (string)

1 Answers  


RMAN-04010: target database Password:

1 Answers  


ORA-31182: Too many PL/SQL DOM handles specified

1 Answers  


Categories