QSM-00508: statistics missing on tables/columns



QSM-00508: statistics missing on tables/columns..

Answer / guest

Cause: The system metadata does not contain statistics on
one or more tables or columns. The Advisor needs
cardinalities of all fact-tables, and of the level-keys of
all dimensions in the data warehouse.

Action: Run ANALYZE on the tables and summaries 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-12649: Unknown encryption or data integrity algorithm

1 Answers  


ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches

1 Answers  


SQL*Loader-00408: Physical record stack overflow

1 Answers  


ORA-02037: uninitialized speed bind storage

1 Answers  


ORA-01224: group number in header string does not match GROUP string

1 Answers  






ORA-30367: a JOIN KEY clause is required

1 Answers  


ORA-13220: failed to compare tile with the geometry

1 Answers  


NNL-00257: Server-generated requests currently require authoritative answers

1 Answers  


ORA-24399: invalid number of connections specified

1 Answers  


NNO-00064: loading domain data from checkpoint file "string"

1 Answers  


ORA-01681: max # extents (string) reached in LOB segment in tablespace string

1 Answers  


TNS-00250: Navigator has been started

1 Answers  


Categories