QSM-01101: rollup(s) took place on mv, string



QSM-01101: rollup(s) took place on mv, string..

Answer / guest

Cause: If query's GROUP BY has one of the higher levels of
columns found in the materialized view, then the lower level
columns in the materialized view will be rolled up to
compute the desired results.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00404: Column string present more than once in string's INTO TABLE block.

1 Answers  


ORA-32304: materialized views with user-defined types cannot use prebuilt table

1 Answers  


ORA-24809: amount specified will not fit in the lob buffers

1 Answers  


ORA-12484: invalid OS label

1 Answers  


ORA-14251: Specified subpartition does not exist

1 Answers  






RMAN-00574: rman aborting due to errors read/writing dbms_pipe

1 Answers  


ORA-16625: cannot reach the primary

1 Answers  


DRG-11100: unable to connect to the database

1 Answers  


PLS-00583: size must be specified if opaque type is fixed-length

1 Answers  


ORA-01555: snapshot too old: rollback segment number string with name "string" too small

1 Answers  


ORA-00217: controlfile could not be resized for migration from 9.0.1

1 Answers  


ORA-30681: improper value for argument EXTENSIONS_CMD_SET

1 Answers  


Categories