QSM-00510: statistics missing on materialized views



QSM-00510: statistics missing on materialized views..

Answer / guest

Cause: The system metadata does not contain statistics on
one or more materialized views. The Advisor needs
cardinalities of all materialized views in the data warehouse.

Action: Run ANALYZE on the tables and materialized views in
the warehouse to collect statistics.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00225: end-element tag "~1S" does not match start-element tag "~2S"

1 Answers  


ORA-29367: object string does not exist

1 Answers  


ORA-15111: conflicting or duplicate STRIPE options

1 Answers  


LPX-00261: invalid URL ~s

1 Answers  


ORA-25283: either agent's name or address needed for non-repudiation

1 Answers  






PCB-00315: DECLARE TABLE is an Oracle extension

1 Answers  


LSX-00111: type "~S" contains invalid facets

1 Answers  


ORA-27486: insufficient privileges

1 Answers  


NNL-00221: Statistic counter logging interval is now string

1 Answers  


ORA-12718: operation requires connection as SYS

1 Answers  


NID-00504: LOGFILE Output Log (NONE)

1 Answers  


TNS-04077: WARNING: No password set for the Oracle Connection Manager instance.

1 Answers  


Categories