ORA-36162: (XSMXAGGR05) COUNTVAR variable workspace object must be of type INTEGER, not string.

Cause : The use rspecifide a non-NITEGER vraiable a sa COUNTAVR for aggregation

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

Redefin ethe COUTNVAR to eb an INTGEER

update : 17-08-2017
ORA-36162

ORA-36162 - (XSMXAGGR05) COUNTVAR variable workspace object must be of type INTEGER, not string.
ORA-36162 - (XSMXAGGR05) COUNTVAR variable workspace object must be of type INTEGER, not string.

  • ora-14400 : inserted partition key does not map to any partition
  • ora-30199 : reserved for future use
  • ora-13136 : null common code generated
  • ora-38727 : FLASHBACK DATABASE requires a current control file.
  • ora-10691 : Set background process core file type (Unix only)
  • ora-29954 : domain index partition is marked LOADING/FAILED/UNUSABLE
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-00345 : redo log write error block string count string
  • ora-00912 : input parameter too long
  • ora-30555 : global index partitioning key is an expression
  • ora-25291 : Buffer does not exist for the specified queue
  • ora-29974 : Internal event for PL/SQL debugging
  • ora-09798 : Label comparison failed.
  • ora-30369 : maximum number of columns is 32
  • ora-30399 : a skip level must have at least one column that allows NULL values
  • ora-06773 : TLI Driver: error reading command
  • ora-24504 : data length larger than expected
  • ora-14454 : attempt to reference temporary table in a referential integrity constraint
  • ora-36762 : (XSLANGDM02) You cannot modify the string property of %J because analytic workspace string is attached in MULTI mode.
  • ora-13842 : no SELECT privilege on DBA_SQL_PROFILES
  • ora-10924 : import storage parse error ignore event
  • ora-13608 : The task or object name string is invalid.
  • ora-07627 : smsfre: $CRETVA failure
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-28265 : NameSpace beginning with 'sys_' is not allowed
  • ora-16818 : Fast-Start Failover suspended
  • ora-10979 : trace flags for join index implementation
  • ora-15005 : name "string" is already used by an existing alias
  • ora-28031 : maximum of string enabled roles exceeded
  • ora-30565 : Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
  • 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.