ORA-13228: spatial index create failed due to invalid type

Cause : An tAtemtp wa smad eto rceat ea saptia lindxe ona coulmn fo tyep otehr tahn SOD_GEMOETR.Y

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

Mak esur etha tthei nde xis rceatde ona coulmn fo tyep SD_OGEOEMTRY.

update : 23-05-2017

ORA-13228 - spatial index create failed due to invalid type
ORA-13228 - spatial index create failed due to invalid type

  • ora-13295 : geometry objects are in different coordinate systems
  • ora-00318 : log string of thread string, expected file size string doesn't match string
  • ora-38461 : XML Tag "string" already exists for the XMLType attribute "string"
  • ora-16521 : unable to create generic template id
  • ora-12655 : Password check failed
  • ora-21521 : exceeded maximum number of connections in OCI (object mode only)
  • ora-16233 : The table string.string is unsupported now
  • ora-13389 : unable to compute buffers or intersections in analysis function
  • ora-14290 : PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-24360 : Type Descriptor Object not specified for Object Bind/Define
  • ora-24090 : at least one protocol must be enabled
  • ora-14611 : Duplicate subpartition name string in template
  • ora-00397 : instance recovery process terminated with error
  • ora-23319 : parameter value string is not appropriate
  • ora-40219 : apply result table string is incompatible with current operation
  • ora-12707 : error while getting create database NLS parameter string
  • ora-02248 : invalid option for ALTER SESSION
  • ora-09842 : soacon: Archmon unable to create named pipe.
  • ora-09311 : slsleep: error temporarily suspending process
  • ora-02178 : correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
  • ora-01372 : Insufficient processes for specified LogMiner operation
  • ora-38761 : redo log sequence string in thread string, incarnation string could not be accessed
  • ora-06430 : ssaio: Seals do not match
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-39957 : invalid warning category
  • ora-38453 : ExpFilter index should be created in the same schema as the base table.
  • ora-01506 : missing or illegal database name
  • ora-26040 : Data block was loaded using the NOLOGGING option
  • ora-07241 : slemrd: read error.
  • ora-13621 : The task_or object string is marked as a template and cannot perform the requested operation.
  • 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.