ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree

Cause : Currently, an R-tree index with three or more index dimensions can be used only with the SDO_FILTER operator.

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

Use the SDO_FILTER operator, and check the documentation for the querytype parameter for SDO_FILTER; or contact Oracle Support Services.

update : 30-04-2017

ORA-13243 - specified operator is not supported for 3- or higher-dimensional R-tree
ORA-13243 - specified operator is not supported for 3- or higher-dimensional R-tree

  • ora-36842 : (XSLMGEN12) Hierarchy string.string!string.string was not found
  • ora-17506 : I/O Error Simulation
  • ora-08437 : invalid picture type in picture mask
  • ora-02803 : Retrieval of current time failed
  • ora-22062 : invalid input string [string]
  • ora-12415 : A column of another datatype exists on the specified table
  • ora-09215 : sfqio: error detected in IOCompletionRoutine
  • ora-07565 : sldext: $SEARCH failure
  • ora-08007 : Further changes to this block by this transaction not allowed
  • ora-25530 : FAST_START_MTTR_TARGET is not specified
  • ora-12403 : invalid internal label
  • ora-30743 : "string" is not an object view
  • ora-16537 : child count exceeded
  • ora-24781 : branches don't belong to the same global transaction
  • ora-22335 : The client cannot work with an altered type
  • ora-14513 : partitioning column may not be of object datatype
  • ora-16604 : unable to describe template using package "string"
  • ora-29361 : value string is outside valid range of 0 to 100
  • ora-32001 : write to SPFILE requested but no SPFILE specified at startup
  • ora-03287 : invalid FREELIST GROUP specified
  • ora-00236 : snapshot operation disallowed: mounted control file is a backup
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-12315 : database link type is invalid for the ALTER DATABASE statement
  • ora-39137 : cannot specify a TABLE_EXISTS_ACTION of string for a job with no metadata
  • ora-02246 : missing EVENTS text
  • ora-07210 : slcpu: getrusage error, unable to get cpu time.
  • ora-16799 : Redo Apply is offline
  • ora-33076 : (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • ora-16128 : User initiated stop apply successfully completed
  • 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.