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

RMAN-06441: cannot upgrade catalog - catalog is already newer than this RMAN

1 Answers  


ORA-22314: method information mismatch in ALTER TYPE

1 Answers  


LSX-00160: invalid substitution group affiliation between "~S" and "~S"

1 Answers  


ORA-24125: Object string.string has changed

1 Answers  


RMAN-03038: Spooling started in trace file: string

1 Answers  






ORA-07618: $IDTOASC failed translating a secrecy level

1 Answers  


ORA-12598: TNS:banner registration failed

1 Answers  


ORA-00260: cannot find online log sequence string for thread string

1 Answers  


ORA-13360: invalid subtype in a compound type

1 Answers  


ORA-34896: (PPMONTHS00) At least 12 month names must be given. Only number were provided.

1 Answers  


RMAN-06306: ====================

1 Answers  


ORA-00368: checksum error in redo log block

1 Answers  


Categories