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 : 24-06-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-28522 : error initializing heterogeneous capabilities
  • ora-36698 : (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.
  • ora-23542 : dependent object "string"."string" already registered
  • ora-13344 : an arcpolygon geometry has fewer than five coordinates
  • ora-12455 : internal error in Label Security MMON cleanup task
  • ora-19028 : Invalid ADT parameter passed to toObject() function
  • ora-14172 : invalid ALTER TABLE EXCHANGE SUBPARTITION option
  • ora-06544 : PL/SQL: internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-02790 : File name is too long
  • ora-02792 : Unable to fstat() a file being used for asynchronous I/O.
  • ora-10633 : No space found in the segment
  • ora-29848 : error occurred in the execution of ODCIINDEXMERGEPARTITION routine
  • ora-29875 : failed in the execution of the ODCIINDEXINSERT routine
  • ora-23411 : materialized view "string"."string" is not in refresh group "string"."string"
  • ora-23398 : user name "string" at database link "string" does not match local user name "string"
  • ora-08309 : sllfop: Cannot fstat file
  • ora-12825 : explicit degree of parallelism must be specified here
  • ora-02814 : Unable to get shared memory
  • ora-36912 : (XSAGDNGL48) In AGGMAP workspace object, MODEL workspace object cannot be simultaneous.
  • ora-24786 : separated transaction has been completed
  • ora-19663 : cannot apply current offline range to datafile string
  • ora-39110 : error deleting worker processes
  • ora-32304 : materialized views with user-defined types cannot use prebuilt table
  • ora-12084 : must use ALTER MATERIALIZED VIEW to alter "string"."string"
  • ora-24414 : Only number sessions could be started.
  • ora-29953 : cannot issue DDL on a domain index partition marked as FAILED
  • ora-06976 : X.25 Driver: endpoint creation failure
  • ora-00275 : media recovery has already been started
  • ora-07506 : scgrl: $deq unexpected return on lockid string
  • ora-27508 : IPC error sending a message
  • 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.