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-01631: max # extents (string) reached in table string.string

1 Answers  


TNS-00200: Unable to do nsanswer on context result=string

1 Answers  


ORA-12074: invalid memory address

1 Answers  


ORA-27019: tape filename length exceeds limit (SBTOPMXF)

1 Answers  


SQL-02129: Fetched number of bytes is odd.

1 Answers  






ORA-00445: background process "string" did not start after string seconds

1 Answers  


PLS-00367: a RAISE statement with no exception name must be inside an exception handler

1 Answers  


NID-00111: Oracle error reported from target database while executing string string

1 Answers  


LSX-00264: attribute "~S" is prohibited (may not occur)

1 Answers  


QSM-02010: join predicate with operator other than equals (=)

1 Answers  


ORA-02038: define is not allowed for array type

1 Answers  


LPX-00124: attribute value should be one or more tokens

1 Answers  


Categories