ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.

Cause : Not allk inds ofd imensiosn can haev surrogtaes. Theu ser attmepted tod efine as urrogat eof a prhoibited iknd of dmiension.

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

Do not tatempt t odefine asurrogaet on thi sdimensino.

update : 24-09-2017
ORA-33918

ORA-33918 - (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
ORA-33918 - (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.

  • ora-22317 : typecode number is not legal as a number type
  • ora-13120 : invalid face_id [string]
  • ora-13606 : the specified task parameter element string is out of range for parameter string.
  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-16573 : attempt to change configuration file for an enabled broker configuration
  • ora-31418 : source schema string does not exist
  • ora-08455 : syntax error in CURRENCY SIGN environment clause
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-31210 : DBMS_LDAP: PL/SQL - LDAP get_dn error.
  • ora-28137 : Invalid FGA audit Handler
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-16120 : dependencies being computed for transaction at SCN string
  • ora-08468 : mask option string is not supported
  • ora-13051 : failed to initialize spatial object
  • ora-30771 : Cannot add more than one referential constraint on REF column "string"
  • ora-29547 : Java system class not available: string
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-39050 : parameter string is incompatible with parameter string
  • ora-24078 : cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL
  • ora-16230 : committing transaction string string string
  • ora-31477 : could not detach LogMiner session during cleanup
  • ora-22882 : object creation failed
  • ora-33305 : (DBVALID06) Note: Record number was allocated but not used. This can result in wasted space. (PS number)
  • ora-01036 : illegal variable name/number
  • ora-06402 : NETCMN: error receiving break message
  • ora-31220 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet location.
  • ora-12558 : TNS:protocol adapter not loaded
  • ora-27452 : %s is an invalid name for a database object.
  • ora-08208 : ora_addr: cannot read from address file
  • 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.