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-06-2017
ORA-13228

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

  • ora-19715 : invalid format string for generated name
  • ora-31501 : change source string is not an AutoLog change source
  • ora-22970 : name does not correspond to an object view
  • ora-13862 : Statistics aggregation for client identifier string is not enabled
  • ora-24235 : bad value for object type: string
  • ora-01680 : unable to extend LOB segment by string in tablespace string
  • ora-02060 : select for update specified a join of distributed tables
  • ora-23538 : cannot explicitly refresh a NEVER REFRESH materialized view ("string")
  • ora-29909 : label for the ancillary operator is not a literal number
  • ora-31198 : Mismatch in number of bytes transferred due to non-binary mode
  • ora-14509 : specified VALIDATE INTO table form incorrect
  • ora-07552 : sftget: $GET failure
  • ora-08234 : smsget: cannot get instance listener address
  • ora-13378 : invalid index for element to be extracted
  • ora-12432 : LBAC error: string
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-13753 : "SQL Tuning Set" "string" already exists for user "string".
  • ora-24817 : Unable to allocate the given chunk for current lob operation
  • ora-24813 : cannot send or receive an unsupported LOB
  • ora-30552 : The package/procedure/function cannot be changed
  • ora-30451 : internal error
  • ora-29888 : cannot create domain index on a table with row movement enabled
  • ora-15111 : conflicting or duplicate STRIPE options
  • ora-13911 : Threshold not found
  • ora-21301 : not initialized in object mode
  • ora-16416 : Switchover target is not synchronized with the primary
  • ora-24171 : creation properties are only for internal use
  • ora-15011 : failure group "string" contains no members
  • ora-00203 : using the wrong control files
  • ora-16045 : circular archive log destination dependency chain
  • 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.