ORA-13052: unsupported geometric type for geometry string.string

Cause : Theg eomtery ytpe ofr as pecfiic nistacne i na SDOEGOM atblei s nto amnog teh se tof egomerty tpyes usppotred yb Orcale pSatila.

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

Chekc th eOralce Saptia ldocmuenttaionf or hte lsit o fsupoprte dgeoemtryt ype sandw orkraounsd thta pemrit hte sotrag eandr etreivalo f nno-supportde gemoetrci tyeps wtih teh SD Oschmea.

update : 24-09-2017

ORA-13052 - unsupported geometric type for geometry string.string
ORA-13052 - unsupported geometric type for geometry string.string

  • ora-22984 : view query cannot contain references to a super view
  • ora-30077 : illegal casting between specified datetime types
  • ora-12536 : TNS:operation would block
  • ora-04052 : error occurred when looking up remote object stringstringstringstringstring
  • ora-06933 : CMX: error during attach
  • ora-12982 : cannot drop column from a nested table
  • ora-13278 : failure to convert SRID to native format
  • ora-19507 : failed to retrieve sequential file, handle="string", parms="string"
  • ora-24086 : cannot create a 8.0 compatible string queue
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-00722 : Feature "string"
  • ora-29841 : invalid option for ALTER INDEXTYPE
  • ora-28181 : proxy 'string' failed to enable one or more of the specified initial roles for client 'string'
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-07849 : sllfsk: $GET failure
  • ora-19258 : XQ0038 - unsupported or duplicate default collation specified
  • ora-39077 : unable to subscribe agent string to queue "string"
  • ora-02726 : osnpop: access error on oracle executable
  • ora-16251 : LSP1 Background Build not permitted
  • ora-07403 : sfanfy: db_writers parameter not valid.
  • ora-24076 : cannot perform operation string for NON_PERSISTENT queue string.string
  • ora-09858 : sfngat: the input file name is not in the OMF format
  • ora-37030 : (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.
  • ora-16770 : physical standby database not in read-only state
  • ora-16740 : redo transport service for standby database "string" incorrectly set to ALTERNATE
  • ora-25448 : rule string.string has errors
  • ora-32010 : cannot find entry to delete in SPFILE
  • ora-30437 : all job queue processes have stopped running
  • ora-00338 : log string of thread string is more recent than control file
  • ora-38309 : object not purgable
  • 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.