Index MSEG-BUD could not created

[Former Member]

Hi Experts,

Our Database was recently upgraded to oracle 12c. when creating index for MSEG table we are getting error ORA-00039 error  and ora-04036. Attached is error screenshot .Please anyone could suggest if there will be any impact if PGA_AGGREGATE_LIMIT parameter value changed to 0 .

Regards,

Sharma

[JamesZ]

Hi Sharma,

set it to 0 can disable the feature of pga limit, which could solve this issue.

Since SAP has very strict rule on oracle parameters (Every parameter needs to be verified by SAP) and there is no SAP note talks this parameter, so please raise a ticket to SAP.

Best regards,
James