Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-14193: invalid ALTER INDEX MODIFY SUBPARTITION option

1 Answers  


IMP-00094: Warning: The identifier on the dump file for object type "string"."string" is invalid

1 Answers  


NZE-29226: No matching private key found.

1 Answers  


ORA-32058: operation restricted to SYSDBA users

1 Answers  


LPX-00203: could not read from "~s" (error ~u)

1 Answers  






ORA-21702: object is not instantiated or has been de-instantiated in cache

1 Answers  


ORA-30375: materialized view cannot be considered fresh

1 Answers  


ORA-19038: Invalid opertions on query context

1 Answers  


ORA-10577: Can not invoke test recovery for managed standby database recovery

1 Answers  


RMAN-08583: channel string: archivelog copy complete, elapsed time: string

1 Answers  


ORA-13631: The task string contains no execution results.

1 Answers  


ORA-00332: archived log is too small - may be incompletely archived

1 Answers  






Categories