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 : 28-05-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-02355 : error opening file: string
  • ora-36763 : (XSAGGCNTMOVE01) Aggregation variable workspace object cannot have itself as an AGGCOUNT.
  • ora-08264 : ora_addr: cannot close nameserver
  • ora-30934 : 'string' (string node) cannot be inserted in parent 'string' (string node)
  • ora-12416 : policy string not found
  • ora-00408 : parameter string is set to TRUE
  • ora-01757 : Must specify an object number
  • ora-10663 : Object has rowid based materialized views
  • ora-02729 : osncon: driver not in osntab
  • ora-02083 : database name has illegal character 'string'
  • ora-13347 : the coordinates defining an arc are not distinct
  • ora-19809 : limit exceeded for recovery files
  • ora-01109 : database not open
  • ora-19631 : archivelog record contains no file name
  • ora-12534 : TNS:operation not supported
  • ora-23467 : flavor lacks object "string"."string"
  • ora-09888 : osnTXtt: txipc channel creation failed
  • ora-37175 : column string is not a column of source data
  • ora-14112 : RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition
  • ora-16417 : Activation occurred after recovery from standby redo log files; a full database backup is required
  • ora-27010 : skgfwrt: write to file failed
  • ora-13225 : specified index table name is too long for a spatial index
  • ora-28276 : Invalid ORACLE password attribute.
  • ora-16539 : task element not found
  • ora-37116 : OLAP API table function error: (string)
  • ora-31668 : Timeout before worker process string finished initialization.
  • ora-13752 : User "string" must be SYS or must have the "ADMINISTER ANY SQL TUNING SET" privilege.
  • ora-01952 : system privileges not granted to 'string'
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-23436 : missing template authorization for user
  • 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.