Oracle Error ORA-03202: the scan limit specification is invalid

Oracle Error Message

ORA-03202: the scan limit specification is invalid

Reason for the Error

the scan limit did not have a positive integer value the number of freelist groups in the segment

Solution

use a correct scan limit