Oracle Error ORA-38445: TOP clause not allowed with no statistics

Oracle Error Message

ORA-38445: TOP clause not allowed with no statistics

Reason for the Error

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

Solution

Collect statistics for the expression set and try again.