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 : 26-07-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-32158 : Invalid type passed
  • ora-32830 : result code string returned by Messaging Gateway agent
  • ora-07229 : slcpuc: error in getting number of CPUs.
  • ora-01422 : exact fetch returns more than requested number of rows
  • ora-30015 : previously offlined undo tablespace 'string' is still pending
  • ora-01293 : mounted database required for specified LogMiner options
  • ora-23453 : requested operation is not supported on top flavor
  • ora-01201 : file string header failed to write correctly
  • ora-02144 : no option specified for ALTER CLUSTER
  • ora-36394 : (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
  • ora-12706 : this CREATE DATABASE character set is not allowed
  • ora-36908 : (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.
  • ora-38722 : ON or OFF expected.
  • ora-29518 : name string resolved to an object in schema string that is not a Java class
  • ora-23300 : %s
  • ora-15062 : ASM disk is globally closed
  • ora-32310 : object materialized views must select from an object table
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-00103 : invalid network protocol; reserved for use by dispatchers
  • ora-32848 : foreign queue DOMAIN required for JMS unified connections
  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-38775 : cannot disable flash recovery area - flashback database is enabled
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-12322 : unable to mount database (link name string)
  • ora-01658 : unable to create INITIAL extent for segment in tablespace string
  • ora-07607 : szaud: $SNDOPR failure
  • ora-19007 : Schema string does not match expected string.
  • ora-16781 : the status of redo transport service for a database is unknown
  • ora-38787 : Creating the first guaranteed restore point requires mount mode when flashback database is off.
  • ora-01911 : CONTENTS keyword expected
  • 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.