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

QSM-02170: tables must be identical across the UNION operator

1 Answers  


ORA-28507: error in data dictionary view string

1 Answers  


ORA-07759: slemtr: invalid destination

1 Answers  


ORA-16209: Logical standby dictionary build failed to complete.

1 Answers  


ORA-12045: invalid ALTER MATERIALIZED VIEW LOG option

1 Answers  






ORA-28291: No Kerberos Principal Value found.

1 Answers  


NZE-28750: unknown error

1 Answers  


ORA-01302: dictionary build options missing or incorrect

1 Answers  


NNL-00560: Shows or sets the server's request-processing delay

1 Answers  


ORA-06548: no more rows needed

1 Answers  


ORA-00131: network protocol does not support registration 'string'

1 Answers  


ORA-07243: supplied buffer not big enough to hold entire line

1 Answers  


Categories