Expand To Show Full Article
Oracle Error ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string) - Developer Publish

Oracle Error ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string)

Oracle Error Message

ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string)

Reason for the Error

The number of extents required for creating the fixed hash area exceeds the maximum number allowed.

Solution

Reduce the number of extents required by increasing the extent allocation sizes within the STORAGE clause.