ORA-36976: (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID [relation1] INTO {variable | relation2 | surrogate} [USING levelrelation] [INHIERARCHY {inhvariable | valueset}] [LEVELORDER levelordervs] The source relation can be omitted only when using both surrogate gid and level order valueset.

Cause : Comman dfomrati s ont ocrrcet.

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

Chcek hte bojetc tpye nad unmbre, nad igvet hec orerctf oramt.

update : 27-05-2017
ORA-36976

ORA-36976 - (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID [relation1] INTO {variable | relation2 | surrogate} [USING levelrelation] [INHIERARCHY {inhvariable | valueset}] [LEVELORDER levelordervs] The source relation can be omitted only when using both surrogate gid and level order valueset.
ORA-36976 - (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID [relation1] INTO {variable | relation2 | surrogate} [USING levelrelation] [INHIERARCHY {inhvariable | valueset}] [LEVELORDER levelordervs] The source relation can be omitted only when using both surrogate gid and level order valueset.

  • ora-31157 : Invalid Content-Type charset
  • ora-30131 : number of keys being set exceeds allocation
  • ora-24090 : at least one protocol must be enabled
  • ora-30735 : cannot create multiple subtables of the same type under a supertable
  • ora-30348 : ADD and DROP cannot both be specified
  • ora-23383 : registration for materialized view repgroup "string"."string" failed at site string
  • ora-39149 : cannot link privileged user to non-privileged user
  • ora-24348 : Update or Delete without Where
  • ora-01165 : MAXDATAFILES may not exceed string
  • ora-02147 : conflicting SHARED/EXCLUSIVE options
  • ora-07487 : scg_init_lm: cannot create lock manager instance.
  • ora-28658 : This operation is supported only for Index-Organized tables
  • ora-37115 : New OLAP API history is not allowed
  • ora-01605 : missing numbers in clause "string" of string
  • ora-00222 : operation would reuse name of a currently mounted control file
  • ora-16560 : unable to convert document, syntax error at "string"
  • ora-12527 : TNS:listener: all instances are in restricted mode or blocking new connections
  • ora-36640 : (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
  • ora-32822 : subscriber string is marked for removal
  • ora-09314 : sltln: error translating logical name
  • ora-25442 : too many column values for table alias: string
  • ora-25954 : missing primary key or unique constraint on dimension
  • ora-29967 : Cannot drop an operator binding with dependent objects
  • ora-28279 : Error reading ldap_directory_access init parameter.
  • ora-03204 : the segment type specification should indicate partitioning
  • ora-14511 : cannot perform operation on a partitioned object
  • ora-38734 : Flashback log is inconsistent; belongs to another database.
  • ora-26011 : Cannot load type string into column string in table string
  • ora-10265 : Keep random system generated output out of error messages
  • ora-06302 : IPA: Cannot connect to remote host
  • 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.