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

PCC-02350: cannot equivalence this SQL type

1 Answers  


ORA-29336: Internal error [string] [string] from DBMS_PLUGTS

1 Answers  


ORA-25184: column name expected

1 Answers  


ORA-09858: sfngat: the input file name is not in the OMF format

1 Answers  


PLS-00229: Attribute expression within SQL expression

1 Answers  






ORA-29273: HTTP request failed

1 Answers  


ORA-24404: connection pool does not exist

1 Answers  


RMAN-06080: SWITCH required for datafile string

1 Answers  


ORA-07441: function address must be aligned on string byte boundary

1 Answers  


ORA-26669: parameter string inconsistent with parameter string

1 Answers  


ORA-30071: conversion between datetime/interval and string fail

1 Answers  


IMG-02009: 2FF09 - texture feature cannot be determined

1 Answers  


Categories