QSM-00792: the specified SQL statement cannot be stored in
the workload because one or more tables have missing statistics



QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables ..

Answer / guest

Cause: The user attempted to add a workload statement that
contains a table without statistics. Access Advisor requires
all referenced tables to have valid statistics.

Action: Validate the workload statement and retry the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14619: resulting List subpartition(s) must contain at least 1 value

1 Answers  


NPL-00302: ASN.1 type tag is greater than maximum of 16383

1 Answers  


RMAN-06910: can not invoke parallel recovery for test recovery

1 Answers  


AMD-00123: dimension #string: analytic workspace hierarchy dimension value not specified

1 Answers  


TNS-04066: The following log events can be enabled or disabled:

1 Answers  






ORA-08177: can't serialize access for this transaction

1 Answers  


DRG-10011: invalid object name string

1 Answers  


PCC-02204: EXEC SQL INCLUDE not permitted from within an included file

1 Answers  


NNO-00059: cannot construct topology checkpoint file name

1 Answers  


NZE-28764: failure to retrieve a configuration parameter

1 Answers  


QSM-01070: equivalence class manager was not found

1 Answers  


PLS-00360: cursor declaration without body needs return type

1 Answers  


Categories