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

ORA-08265: create_ora_addr: cannot open nameserver

1 Answers  


ORA-29379: resource plan string is involved in a loop in top-plan string

1 Answers  


ORA-33445: (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.

1 Answers  


DGM-16944: Failover succeeded. New primary is "string"

1 Answers  


ORA-23418: cannot unregister the propagator who is currently in use

1 Answers  






ORA-26082: load of overlapping segments on table string.string is not allowed

0 Answers  


NNL-00931: Requests refused, no cached meta-data: number

1 Answers  


AMD-00123: dimension #string: analytic workspace hierarchy dimension value not specified

1 Answers  


QSM-02016: clustered table in FROM list

1 Answers  


TNS-01191: Failed to initialize the local OS authentication subsystem

1 Answers  


TNS-00071: where <command> is one of following:

1 Answers  


ORA-28039: cannot validate Kerberos service ticket

1 Answers  


Categories