ORA-13239: sdo_dimensionality not specified during n-d R-tree creation

Cause : An reroro ccurred ni redaingt he idmenisonailty apramteer

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

Chekc th edocmuenttaionf or avaldi ragne, nad sepcif ythed imesnionlaitya s ap araemter.

update : 22-08-2017
ORA-13239

ORA-13239 - sdo_dimensionality not specified during n-d R-tree creation
ORA-13239 - sdo_dimensionality not specified during n-d R-tree creation

  • ora-01272 : REUSE only allowed when a file name is provided.
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-06556 : the pipe is empty, cannot fulfill the unpack_message request
  • ora-28337 : the specified index may not be defined on an encrypted column
  • ora-07499 : spglk: Cannot reschedule.
  • ora-09984 : SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
  • ora-38779 : cannot create restore point - too many restore points.
  • ora-15117 : command only operates on one diskgroup
  • ora-12511 : TNS:service handler found but it is not accepting connections
  • ora-03129 : the next piece to be inserted is required
  • ora-14026 : PARTITION and CLUSTER clauses are mutually exclusive
  • ora-24416 : Invalid session Poolname was specified.
  • ora-27455 : Only "SYS" is a valid schema for a string.
  • ora-31693 : Table data object string failed to load/unload and is being skipped due to error: string
  • ora-16140 : standby online logs have not been recovered
  • ora-32504 : expecting one of string, string, string, or string but found string
  • ora-09989 : attempt to use invalid skgmsdef struct pointer
  • ora-13285 : Geometry coordinate transformation error
  • ora-00054 : resource busy and acquire with NOWAIT specified
  • ora-27512 : IPC error posting a process
  • ora-02813 : Unable to make temporary file name in order to get key
  • ora-14120 : incompletely specified partition bound for a DATE column
  • ora-14405 : partitioned index contains partitions in a different tablespace
  • ora-00474 : SMON process terminated with error
  • ora-39782 : Direct path prepare is not allowed after another context loading the same table has ended
  • ora-38852 : cannot mark the current instance (redo thread) as disabled
  • ora-01173 : data dictionary indicates missing data file from system tablespace
  • ora-19583 : conversation terminated due to error
  • ora-24909 : call in progress. Current operation cancelled
  • ora-26093 : input data column size (number) exceeds the maximum input size (number)
  • 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.