ORA-13031: Invalid Gtype in the SDO_GEOMETRY object for point object

Cause : hTre esia nniavil dDS_OTGPY Enit ehS ODG_OEEMRT Yboejtcw ehert ehV RAARsYa erN LU Lub tht eDS_OTGPY Esin too fytepP IOTN.

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

eViryft ah tht eegmoteirseh va eavil dtgpyse.

update : 28-05-2017

ORA-13031 - Invalid Gtype in the SDO_GEOMETRY object for point object
ORA-13031 - Invalid Gtype in the SDO_GEOMETRY object for point object

  • ora-25134 : keyword TABLE expected
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-26516 : no push transaction acknowledgement
  • ora-06505 : PL/SQL: variable requires more than 32767 bytes of contiguous memory
  • ora-32800 : internal error string
  • ora-40271 : no statistically significant features were found
  • ora-28667 : USING INDEX option not allowed for the primary key of an IOT
  • ora-06256 : NETNTT: remote fork failed
  • ora-10566 : Test recovery has used all the memory it can use
  • ora-01429 : Index-Organized Table: no data segment to store overflow row-pieces
  • ora-14005 : missing RANGE keyword
  • ora-32133 : Cannot get stream from LOB/FILE
  • ora-22892 : scoped table "string" does not exist in schema "string"
  • ora-32147 : Environment not specified
  • ora-01306 : dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
  • ora-02040 : remote database string does not support two-phase commit
  • ora-31186 : Document contains too many nodes
  • ora-27061 : waiting for async I/Os failed
  • ora-13413 : null or invalid resampling parameter
  • ora-12209 : TNS:encountered uninitialized global
  • ora-12810 : PARALLEL_MAX_SERVERS must be less than or equal to string
  • ora-10572 : Test recovery canceled due to errors
  • ora-07509 : scgfal: $deq parent lock unexpected return
  • ora-29804 : missing DATA keyword
  • ora-00128 : this command requires a dispatcher name
  • ora-22886 : scoped table "string" in schema "string" is not an object table
  • ora-12811 : PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string
  • ora-23320 : the request failed because of values string and string
  • ora-24097 : Invalid value string, string should be non-negative
  • ora-38411 : invalid datatype for the column storing expressions
  • 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.