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-04-2017

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-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-01125 : cannot disable media recovery - file string has online backup set
  • ora-22342 : dependent VARRAY column exceeds the maximum inline column size
  • ora-01546 : tablespace contains active rollback segment 'string'
  • ora-13418 : null or invalid parameter(s) for set functions
  • ora-04014 : descending sequences that CYCLE must specify MINVALUE
  • ora-25333 : Buffered Queue to Queue propagation did not connect to the correct instance
  • ora-29555 : Java source, class or resource is not allowed here
  • ora-12465 : Not authorized for read or write on specified groups or compartments
  • ora-23312 : not the masterdef according to string
  • ora-36154 : (XSMXAGGR01) workspace object is not a data variable.
  • ora-32344 : cannot create a secondary materialized view with synonym as base table
  • ora-12911 : permanent tablespace cannot be temporary tablespace
  • ora-01016 : This function can be called only after a fetch
  • ora-23603 : STREAMS enqueue aborted due to low SGA
  • ora-26005 : Invalid handle for direct path load
  • ora-28274 : No ORACLE password attribute corresponding to user nickname exists.
  • ora-12805 : parallel query server died unexpectedly
  • ora-16810 : multiple errors or warnings detected for the database
  • ora-01883 : overlap was disabled during a region transition
  • ora-38451 : index is in an inconsistent state
  • ora-31081 : name not specified for global declaration
  • ora-25014 : cannot change the value of a PARENT reference variable
  • ora-16751 : resource guard encountered errors in switchover to primary database
  • ora-30061 : Internal Event for Savepoint Tracing
  • ora-25232 : duplicate recipients specified for message
  • ora-16747 : logical standby database guard could not be turned on
  • ora-12055 : materialized view definition contains cyclic dependencies with existing materialized views
  • ora-29547 : Java system class not available: 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.