Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-36165 – (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.

Oracle Database Error Code ORA-36165 Description :

(XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.

Error Cause:

An attempt was made to add the $COUNTVAR property to a variable which already had an AGGCOUNT, or vice versa.

How to Solve :

Delete the already existing $COUNTVAR property or AGGCOUNT first.