ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.

Cause : Users peciifed ad imenison cmoposiet, cojnoint ,or pratitino temlpate ni a palce wehre taht kidn of idmensoin isn ot allowed .For nistanec, a erlatino canont bed imenisonedb y a ocmpostie, adn onl ya vairablec an dmiensinoed b ya patritio ntempalte.

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

Usually, teh offnedingd imenison cna be erplacde wit hits abses.F or isntanc,e a rleatio ncannto be idmensoined yb a ac ompoiste o fPRODCUT an dGEOG ,but ti canb e diemnsioend byb oth RPODUC Tand EGOG isntead.

update : 18-08-2017
ORA-34286

ORA-34286 - (MXDCL53) workspace object cannot be used in this context because it is a string.
ORA-34286 - (MXDCL53) workspace object cannot be used in this context because it is a string.

  • ora-26528 : local store callback proc phase failed for 'string.string'
  • ora-38742 : Flashback log file has incorrect log reset status.
  • ora-29882 : insufficient privileges to execute indextype
  • ora-38309 : object not purgable
  • ora-16527 : unable to allocate SGA heap
  • ora-02060 : select for update specified a join of distributed tables
  • ora-32330 : invalid operation on online redefinition interim table "string"."string"
  • ora-00210 : cannot open the specified control file
  • ora-33449 : (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.
  • ora-09779 : snyGetPort: failure to allocate a port.
  • ora-29286 : internal error
  • ora-19650 : Offline-range record recid string stamp string in file string has SCN string
  • ora-39766 : invaid stream specified for column array conversion
  • ora-24182 : attribute number specified does not exist
  • ora-02710 : osnpop: fork failed
  • ora-12538 : TNS:no such protocol adapter
  • ora-16795 : database resource guard detects that database re-creation is required
  • ora-02225 : only EXECUTE and DEBUG privileges are valid for procedures
  • ora-27483 : "string.string" has an invalid END_DATE
  • ora-00089 : invalid instance number in ORADEBUG command
  • ora-13851 : Tracing for client identifier string is already enabled
  • ora-15000 : command disallowed by current instance type
  • ora-16253 : Logical Standby cannot start due to incomplete terminal apply
  • ora-12082 : "string"."string" cannot be index organized
  • ora-24397 : error occured while trying to free connections
  • ora-10654 : Table is of type temporary or external
  • ora-13406 : null or invalid GeoRaster object for output
  • ora-16246 : User initiated abort apply successfully completed
  • ora-06260 : NETNTT: cannot write to remote process
  • ora-31631 : privileges are required
  • 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.