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-07565: sldext: $SEARCH failure

1 Answers  


TNS-04083: Failed to save password

1 Answers  


ORA-31222: DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.

1 Answers  


PLS-00904: insufficient privilege to access object string

1 Answers  


ORA-02054: transaction string in-doubt

1 Answers  






ORA-08234: smsget: cannot get instance listener address

1 Answers  


ORA-27192: skgfcls: sbtclose2 returned error - failed to close file

1 Answers  


NID-00124: Mismatched dbid for datafile string, expected number, found number

1 Answers  


ORA-40221: maximum target cardinality exceeded

1 Answers  


ORA-16156: LGWR archive log dependency not allowed if database is standby protected

1 Answers  


NZE-29240: the cryptographic engine does not recognize the algorithm

1 Answers  


ORA-12087: online redefinition not allowed on tables owned by "string"

1 Answers  


Categories