Oracle Error ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.

Oracle Error Message

ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.

Reason for the Error

The user specified AUTOCOMMIT but not AUTOUPDATE on the AGGREGATE command line, which is illegal

Solution

Either also specify AUTOUPDATE or don’t specify AUTOCOMMIT