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 : 28-04-2017

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

  • ora-31015 : Attempted to insert entry without name
  • ora-31496 : must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
  • ora-13250 : insufficient privileges to modify metadata table entries
  • ora-38796 : Not enough flashback database log data to undo FLASHBACK.
  • ora-02842 : Client unable to fork a server
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-24391 : invalid fetch operation
  • ora-14301 : table-level attributes must be specified before partition-level attributes
  • ora-00359 : logfile group string does not exist
  • ora-24020 : Internal error in DBMS_AQ_IMPORT_INTERNAL, string
  • ora-01588 : must use RESETLOGS option for database open
  • ora-07579 : spini: $DCLEXH failure
  • ora-29371 : pending area is not active
  • ora-24440 : OCI Easy Install mode cannot be initialized
  • ora-29553 : class in use: string.string
  • ora-16011 : Archivelog Remote File Server process in Error state
  • ora-14324 : values being added already exist in DEFAULT partition
  • ora-38480 : creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
  • ora-25138 : %s initialization parameter has been made obsolete
  • ora-25332 : Invalid release value string for queue table compatible parameter
  • ora-06422 : NETCMN: Error in sending data
  • ora-09208 : sftcls: error closing file
  • ora-01690 : sort area size too small
  • ora-02878 : sou2o: Variable smpdidini overwritten
  • ora-30515 : suspend triggers cannot have BEFORE type
  • ora-30399 : a skip level must have at least one column that allows NULL values
  • ora-31504 : cannot alter or drop predefined change source
  • ora-02061 : lock table specified list of distributed tables
  • ora-31214 : DBMS_LDAP: PL/SQL - Invalid LDAP mod type.
  • 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.