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

DRG-12210: error while adding section string

1 Answers  


TNS-00140: Interchange specified was not found in network tables

1 Answers  


ORA-39124: dump file name "string" contains an invalid substitution variable

1 Answers  


ORA-16222: automatic Logical Standby retry of last action

1 Answers  


LPX-00300: no name in attribute set

1 Answers  


ORA-28545: error diagnosed by Net8 when connecting to an agent

2 Answers  


ORA-32109: invalid column or parameter position

1 Answers  


DBV-00200: Block, dba number, already marked corrupted

1 Answers  


ORA-24056: internal inconsistency for QUEUE string and destination string

1 Answers  


TNS-00540: SSL protocol adapter failure

1 Answers  


ORA-13629: The task or object string is being used by another operation.

1 Answers  


SQL-02128: Sessions still exist, not logged off

1 Answers  


Categories