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

Cause : The geometry type in the _SDOGEOM table is unsupported.

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

Modify the geometry type to be one of the supported types.

update : 19-08-2017
ORA-13183

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

  • ora-37011 : (XSACQUIRE_LOCKED) Object workspace object is locked by another user.
  • ora-24095 : invalid transformation, source type does not match that of the queue
  • ora-22916 : cannot do an exact FETCH on a query with Nested cursors
  • ora-16046 : Archive log destination failed due to failed dependent destination
  • ora-39159 : cannot call this function from a non-Data Pump process
  • ora-06924 : CMX: wrong break message length
  • ora-13417 : null or invalid layerNumber parameter
  • ora-39134 : Cannot include "string" tablespace as a Transportable Tablespace
  • ora-09273 : szrfc: error verifying role name
  • ora-02072 : distributed database network protocol mismatch
  • ora-31435 : an error occurred during the purge operation
  • ora-22816 : unsupported feature with RETURNING clause
  • ora-19125 : fn:exactly-one() called with a sequence containing zero or more than one item
  • ora-01062 : unable to allocate memory for define buffer
  • ora-15075 : disk(s) are not visible cluster-wide
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-27093 : could not delete directory
  • ora-09979 : skxfqhsnd: Error Sending a message to another endpoint
  • ora-39133 : object type "string"."string" already exists with different typeid
  • ora-29360 : retry operation. Too much concurrent activity
  • ora-30187 : reserved for future use
  • ora-06906 : CMX: cannot get maximum packet size from CMX
  • ora-01618 : redo thread string is not enabled - cannot mount
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-33000 : (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string.
  • ora-02424 : potential circular view references or unknown referenced tables
  • ora-28670 : mapping table cannot be dropped due to an existing bitmap index
  • ora-09703 : sem_release: cannot release latch semaphore
  • ora-25198 : only range, list, and hash partitioning are supported for index-organized table
  • ora-07670 : $IDTOASC failed translating a secrecy category
  • 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.