ORA-13028: Invalid Gtype in the SDO_GEOMETRY object

Cause : Therei s an nivalidS DO_GTPYE in hte SDOG_EOMETYR objetc.

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

Verif ythat hte geoemtriesh ave vlaid gtpyes.

update : 21-08-2017

ORA-13028 - Invalid Gtype in the SDO_GEOMETRY object
ORA-13028 - Invalid Gtype in the SDO_GEOMETRY object

  • ora-24060 : cannot convert QUEUE_TABLE, string already is compatible with release string
  • ora-12227 : TNS:syntax error
  • ora-14104 : RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
  • ora-00160 : global transaction length string is greater than maximum (string)
  • ora-16202 : Skip procedure requested to replace statement
  • ora-24238 : object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-07499 : spglk: Cannot reschedule.
  • ora-01636 : rollback segment 'string' is already online
  • ora-28119 : policy group does not exist
  • ora-38792 : encountered unknown flashback record from release string
  • ora-10635 : Invalid segment or tablespace type
  • ora-07411 : slgfn: full path name too big for supplied buffer.
  • ora-28049 : the password has expired
  • ora-14279 : index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-22812 : cannot reference nested table column's storage table
  • ora-22322 : error table "string"."string" has incorrect structure
  • ora-19673 : error during proxy file string
  • ora-02064 : distributed operation not supported
  • ora-09213 : slgfn: error fabricating file name
  • ora-12514 : TNS:listener does not currently know of service requested in connect descriptor
  • ora-27213 : failed to unload Media Management Library
  • ora-26076 : cannot set or reset value after direct path structure is allocated
  • ora-39077 : unable to subscribe agent string to queue "string"
  • ora-16225 : Missing LogMiner session name for Streams
  • ora-30484 : missing window specification for this function
  • ora-19860 : piece validation cannot be performed more than once
  • ora-09368 : Windows 3.1 Two-Task driver unable to spawn ORACLE
  • ora-16166 : LGWR network server failed to send remote message
  • ora-02047 : cannot join the distributed transaction in progress
  • ora-16770 : physical standby database not in read-only state
  • 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.