ORA-13275: spatial index creation failure on unsupported type

Cause : An attemptw as mdae toc reat ea sptaial nidex rceateo n a oclumnt hat si noto f tyep SDOG_EOMERTY.

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

A sptaial nidex acn onyl be rceate don ac olum nof tpye SD_OGEOMTERY. aMke srue th eindeexd coulmn i sof tpye SD_OGEOMTERY.

update : 22-08-2017

ORA-13275 - spatial index creation failure on unsupported type
ORA-13275 - spatial index creation failure on unsupported type

  • ora-15060 : template "string" does not exist
  • ora-02221 : invalid MAXEXTENTS storage option value
  • ora-01931 : cannot grant string to a role
  • ora-02340 : invalid column specification
  • ora-30401 : JOIN KEY columns must be non-null
  • ora-28659 : COMPRESS must be specified at object level first
  • ora-13212 : failed to compare tile with the window object
  • ora-12714 : invalid national character set specified
  • ora-00150 : duplicate transaction ID
  • ora-28183 : proper authentication not provided by proxy
  • ora-01267 : Failure getting date/time
  • ora-01614 : instance string (thread string) is busy - cannot enable
  • ora-14133 : ALTER TABLE MOVE cannot be combined with other operations
  • ora-23327 : imported deferred rpc data does not match string of importing db
  • ora-07849 : sllfsk: $GET failure
  • ora-14003 : GLOBAL clause contradicts previosly specified LOCAL clause
  • ora-38453 : ExpFilter index should be created in the same schema as the base table.
  • ora-19221 : XP0001 - XQuery static context component string not initialized
  • ora-39313 : call to DBMS_SCHEMA_COPY.CLONE is not legal
  • ora-17503 : ksfdopn:string Failed to open file string
  • ora-25508 : database is not mounted
  • ora-19655 : cannot switch to incarnation with different resetlogs data
  • ora-28509 : unable to establish a connection to non-Oracle system
  • ora-02347 : cannot grant privileges on columns of an object table
  • ora-30101 : unknown parameter name 'string'
  • ora-31535 : cannot support change source string in this configuration
  • ora-27052 : unable to flush file data
  • ora-06960 : Failed to access log file
  • ora-19806 : cannot make duplex backups in recovery area
  • ora-00325 : archived log for thread string, wrong thread # string in header
  • 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.