ORA-36650: (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.

Cause : Unique concat base dimensions cannot contain duplicate values.

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

Use MAINTAIN RENAME to change one of the duplicate values and retry.

update : 26-05-2017
ORA-36650

ORA-36650 - (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
ORA-36650 - (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.

  • ora-10387 : parallel query server interrupt (normal)
  • ora-24379 : invalid user callback type
  • ora-31668 : Timeout before worker process string finished initialization.
  • ora-24340 : cannot support more than 255 columns
  • ora-29286 : internal error
  • ora-01259 : unable to delete datafile string
  • ora-26744 : STREAMS capture process "string" does not support "string"."string" because of the following reason: string
  • ora-02769 : Setting of handler for SIGTERM failed
  • ora-27372 : length of action and arguments exceeds platform limit string
  • ora-13126 : unable to determine class for spatial table string
  • ora-30160 : Unable to access the file
  • ora-16810 : multiple errors or warnings detected for the database
  • ora-24063 : cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
  • ora-19881 : Corrupted space bitmap for datafile string, block string backup aborted
  • ora-31635 : unable to establish job resource synchronization
  • ora-02087 : object locked by another process in same transaction
  • ora-01977 : Missing thread number
  • ora-40271 : no statistically significant features were found
  • ora-23442 : object already exists for the refresh group template
  • ora-07327 : smpdal: attempt to destroy pga when it was not mapped.
  • ora-09934 : Link of current password file to old failed.
  • ora-04033 : Insufficient memory to grow pool
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-03263 : cannot drop the first file of tablespace string
  • ora-31052 : Cannot delete ACL with other references
  • ora-16560 : unable to convert document, syntax error at "string"
  • ora-02359 : internal error setting attribute string
  • ora-22915 : cannot ALTER a nested table's storage table to ADD/MODIFY columns
  • ora-31602 : parameter string value "string" in function string inconsistent with 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.