ORA-36161: (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR.

Cause : The user specified the same variable as both an aggregation variable and a COUNTVAR

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Specify a different COUNTVAR

update : 26-05-2017

ORA-36161 - (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR.
ORA-36161 - (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR.

  • ora-08331 : Wait operation timed out
  • ora-32814 : propagation schedule string does not exist
  • ora-07458 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-13284 : failure to copy geometry object for conversion in place
  • ora-02703 : osnpopipe: pipe creation failed
  • ora-16546 : missing or invalid piece
  • ora-02855 : Number of requests is less than the number of slaves
  • ora-29557 : Java system class string cannot be modified
  • ora-00251 : LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string
  • ora-02042 : too many distributed transactions
  • ora-38744 : file string is not the same file seen at start of flashback
  • ora-22310 : ALTER TYPE error. Refer to table "string"."string" for errors
  • ora-30392 : the checksum analysis for the rewrite equivalence failed
  • ora-19275 : XP0055 - schema path string not found in list of in-scope schema definitions
  • ora-07713 : sksamtd: could not mount archival device (SYS$MOUNT failure)
  • ora-00356 : inconsistent lengths in change description
  • ora-28552 : pass-through SQL: call flow error
  • ora-19603 : cannot backup or copy active file with KEEP .. UNRECOVERABLE option
  • ora-19611 : backup piece out of order. Expected string but found string
  • ora-29851 : cannot build a domain index on more than one column
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-13441 : GeoRaster metadata SRS error
  • ora-10948 : trace name context forever
  • ora-32583 : query passed to table function has wrong number of elements in select list
  • ora-30570 : SEGMENT SPACE MANAGEMENT option already specified
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-02220 : invalid MINEXTENTS storage option value
  • ora-00036 : maximum number of recursive SQL levels (string) exceeded
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-16116 : no work available
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.