Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NZE-28852: Bad password

1 Answers  


NNL-00812: Slowest query processing time: string

1 Answers  


PCC-02151: Line number column number file string:

1 Answers  


ORA-28279: Error reading ldap_directory_access init parameter.

1 Answers  


ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

1 Answers  






ORA-32841: invalid value for property string

1 Answers  


ORA-02850: File is closed

1 Answers  


RMAN-20231: ambiguous datafilecopy name

1 Answers  


IMG-00825: merged area queue pop failed

1 Answers  


RMAN-08181: media recovery complete, elapsed time: string

1 Answers  


DRG-50953: Unable to determin section name

1 Answers  


ORA-07268: szguns: getpwuid error.

1 Answers  


Categories