ORA-29834: REF datatype not supported with operators

Cause : Theu sers pecfiieda RE Fdattaypew hic his ont spuporetd i nCRETAE OEPRATRO.

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

Reissue hte CERATEO PERTAOR tsateemnt iwthotu th eREFd ataytpe.

update : 26-07-2017
ORA-29834

ORA-29834 - REF datatype not supported with operators
ORA-29834 - REF datatype not supported with operators

  • ora-01623 : log string is current log for instance string (thread string) - cannot drop
  • ora-24907 : invalid pair of callback and recepient protocol attributes
  • ora-13243 : specified operator is not supported for 3- or higher-dimensional R-tree
  • ora-33263 : Could not create analytic workspace string
  • ora-32001 : write to SPFILE requested but no SPFILE specified at startup
  • ora-24438 : Invalid Authentication Handle specified.
  • ora-31103 : Resource locked in shared mode. Cannot add exclusive lock
  • ora-37073 : (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.
  • ora-01120 : cannot remove online database file string
  • ora-16060 : Log file is current
  • ora-30565 : Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
  • ora-19570 : file number string is outside valid range of 1 through string
  • ora-28157 : Proxy user 'string' forbidden to set role 'string' for client 'string'
  • ora-30068 : Internal Event to turn on nested
  • ora-29397 : cannot grant/revoke switch privilege for string
  • ora-00490 : PSP process terminated with error
  • ora-29954 : domain index partition is marked LOADING/FAILED/UNUSABLE
  • ora-27146 : post/wait initialization failed
  • ora-25526 : bad format of _DB_MTTR_SIM_TARGET: string
  • ora-37107 : (XSVPART07) Attempt to write to non-existent partition of workspace object.
  • ora-32805 : identifier for string too long, maximum length is string characters
  • ora-32771 : cannot add file to bigfile tablespace
  • ora-16658 : unobserved Fast-Start Failover configuration
  • ora-35952 : (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number.
  • ora-01922 : CASCADE must be specified to drop 'string'
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-12200 : TNS:could not allocate memory
  • ora-14054 : invalid ALTER TABLE TRUNCATE PARTITION option
  • ora-30975 : invalid Order Key Index option for XML Index
  • ora-15056 : additional error message
  • 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.