ORA-38445: TOP clause not allowed with no statistics



ORA-38445: TOP clause not allowed with no statistics..

Answer / guest

Cause: An attempt was made to use the TOP parameters clause
with no statistics available for the expression set.

Action: Collect statistics for the expression set and try again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02852: Invalid critical-section time out value

1 Answers  


ORA-21614: constraint violation for attribute number [string]

1 Answers  


ORA-09754: sppst: invalid process number passed to sppst.

1 Answers  


ORA-39054: missing or invalid definition of the SQL output file.

1 Answers  


ORA-29955: error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine

1 Answers  






ORA-04029: error ORA-string occurred when querying stringstringstring

1 Answers  


ORA-02162: invalid value for MAXDATAFILES

1 Answers  


TNS-12634: Memory allocation failed

1 Answers  


RMAN-08119: skipping backup piece handle string; already exists

1 Answers  


ORA-13216: failed to update spatial index

1 Answers  


ORA-31012: Given XPATH expression not supported

1 Answers  


ORA-00352: all logs for thread string need to be archived - cannot enable

1 Answers  


Categories