How to fix the Oracle error ORA-36728: (XSALERR01) While performing the ALLOCATE command with AGGMAP workspace object, the error logging limit of number was exceeded.?

In this post, you’ll learn more about the Oracle ErrorORA-36728: (XSALERR01) While performing the ALLOCATE command with AGGMAP workspace object, the error logging limit of number was exceeded. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36728: (XSALERR01) While performing the ALLOCATE command with AGGMAP workspace object, the error logging limit of number was exceeded.

Reason for the Error ORA-36728: (XSALERR01) While performing the ALLOCATE command with AGGMAP workspace object, the error logging limit of number was exceeded.

The user specified an ERRORLOG MAX value in the ALLOCMAP, but more errors were encountered while performing the allocation.

How to fix the Error ORA-36728: (XSALERR01) While performing the ALLOCATE command with AGGMAP workspace object, the error logging limit of number was exceeded. ?

You can fix this error in Oracle by following the below steps

Either set ERRORLOG NOSTOP, reduce the allocation errors, or increase the ERRORLOG MAX setting