ORA-36988: (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.

Cause : The related dimension of the destination relation has the wrong data type.

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

Redefine the destination relation or choose another relation whose related dimension is of type NUMBER.

update : 27-04-2017
ORA-36988

ORA-36988 - (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.
ORA-36988 - (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.

  • ora-25113 : GLOBAL may not be used with a bitmap index
  • ora-19693 : backup piece string already included
  • ora-36267 : (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference.
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-31668 : Timeout before worker process string finished initialization.
  • ora-31670 : Username argument must be specified and non-null.
  • ora-12665 : NLS string open failed
  • ora-01491 : CASCADE option not valid
  • ora-16402 : ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support
  • ora-07235 : slemcw: fwrite error.
  • ora-13525 : error with computing space usage for sysaux occupant
  • ora-30479 : Summary Advisor error string
  • ora-09280 : sllfcf: error closing file
  • ora-01372 : Insufficient processes for specified LogMiner operation
  • ora-09989 : attempt to use invalid skgmsdef struct pointer
  • ora-06730 : TLI Driver: unable to open clone device
  • ora-37020 : (XSMULTI01) Analytic workspace string is not in MULTI mode.
  • ora-02225 : only EXECUTE and DEBUG privileges are valid for procedures
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-16654 : Fast-Start Failover is enabled
  • ora-25142 : default storage clause specified twice
  • ora-07629 : smpall: $EXPREG failure
  • ora-28339 : missing or invalid encryption algorithm
  • ora-13300 : single point transform error
  • ora-12404 : invalid privilege string: string
  • ora-39961 : message specified was not found
  • ora-23608 : invalid resolution column "string"
  • ora-12511 : TNS:service handler found but it is not accepting connections
  • ora-13518 : Invalid database id (string)
  • 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.