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-07-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-06747 : TLI Driver: error in listen
  • ora-39024 : wrong schema specified for job
  • ora-19769 : missing FILE keyword
  • ora-13114 : [string]_NODE$ table does not exist
  • ora-13425 : function not implemented
  • ora-15173 : entry 'string' does not exist in directory 'string'
  • ora-03299 : cannot create dictionary table string
  • ora-00023 : session references process private memory; cannot detach session
  • ora-38307 : object not in RECYCLE BIN
  • ora-19589 : %s is not a snapshot or backup control file
  • ora-22617 : error while accessing the image handle collection
  • ora-07208 : sfwfb: failed to flush dirty buffers to disk.
  • ora-26000 : partition load specified but table string is not partitioned
  • ora-22281 : cannot perform operation with an updated locator
  • ora-23411 : materialized view "string"."string" is not in refresh group "string"."string"
  • ora-12221 : TNS:illegal ADDRESS parameters
  • ora-30757 : cannot access type information
  • ora-02349 : invalid user-defined type - type is incomplete
  • ora-29807 : specified operator does not exist
  • ora-07229 : slcpuc: error in getting number of CPUs.
  • ora-01977 : Missing thread number
  • ora-29370 : pending area is already active
  • ora-00209 : control file blocksize mismatch, check alert log for more info
  • ora-01062 : unable to allocate memory for define buffer
  • ora-06010 : NETASY: dialogue file too long
  • ora-01350 : must specify a tablespace name
  • ora-02430 : cannot enable constraint (string) - no such constraint
  • ora-09281 : sllfop: error opening file
  • ora-28577 : argument string of external procedure string has unsupported datatype string
  • ora-19243 : XQ0023 - invalid document node content in element constructor
  • 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.