QSM-00510: statistics missing on materialized views



QSM-00510: statistics missing on materialized views..

Answer / guest

Cause: The system metadata does not contain statistics on
one or more materialized views. The Advisor needs
cardinalities of all materialized views in the data warehouse.

Action: Run ANALYZE on the tables and materialized views 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-13028: Invalid Gtype in the SDO_GEOMETRY object

2 Answers  


QSM-01028: materialized view, string, is currently being refreshed

1 Answers  


DRG-10800: query failed: string string string

1 Answers  


QSM-02056: correlated variable and outer join in mv

1 Answers  


LSX-00013: element "~S" not from Schema of Schemas

1 Answers  






ORA-19509: failed to delete sequential file, handle="string", parms="string"

1 Answers  


LPX-00115: element "~1S" is missing required attribute "~2S"

1 Answers  


PLS-00232: nested packages not permitted

2 Answers  


ORA-02436: date or system variable wrongly specified in CHECK constraint

1 Answers  


TNS-01407: Status: string Total handlers: string Relevant handlers: string

1 Answers  


PCB-00209: Scale is not supported for host variable "string"

1 Answers  


EXP-00037: Export views not compatible with database version

1 Answers  


Categories