ORA-13029: Invalid SRID in the SDO_GEOMETRY object

Cause : There si an inavlid SD_OSRID i nthe SD_OGEOMETYR objec.t The sepcifiedS RID ma ybe outisde thev alid SIRD rang.e

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

Verifyt hat th egeometires hav evalid RSIDs.

update : 30-05-2017

ORA-13029 - Invalid SRID in the SDO_GEOMETRY object
ORA-13029 - Invalid SRID in the SDO_GEOMETRY object

  • ora-23366 : integer value string is less than 1
  • ora-25216 : invalid recipient, either NAME or ADDRESS must be specified
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-36618 : (XSAGMODDIM00) workspace object is not a valid model for AGGMAP ADD.
  • ora-29958 : fatal error occurred in the execution of ODCIINDEXCREATE routine
  • ora-02249 : missing or invalid value for MAXLOGMEMBERS
  • ora-30515 : suspend triggers cannot have BEFORE type
  • ora-15090 : handle string is not a valid descriptor
  • ora-22286 : insufficient privileges on file or directory to perform string operation
  • ora-38860 : cannot FLASHBACK DATABASE during instantiation of a logical standby
  • ora-25109 : standby lock name space has illegal character 'string'
  • ora-16114 : applying DDL transaction with commit SCN string
  • ora-30041 : Cannot grant quota on the tablespace
  • ora-37154 : OLAP API initialization error: (case string)
  • ora-40220 : maximum number of attributes exceeded
  • ora-13529 : Error occurred when flushing AWR table group
  • ora-12219 : TNS:missing community name from address in ADDRESS_LIST
  • ora-32003 : error occured processing parameter 'string'
  • ora-00828 : specified value of shared_pool_reserved_size inconsistent with internal settings
  • ora-02355 : error opening file: string
  • ora-06902 : CMX: cannot attach to cmx subsystem
  • ora-07245 : sfccf: unable to lseek and write the last block.
  • ora-15021 : parameter "string" is not valid in string instance
  • ora-30943 : XML Schema 'string' is dependent on XML schema 'string'
  • ora-30068 : Internal Event to turn on nested
  • ora-27513 : parameter string contains invalid value string
  • ora-14260 : incorrect physical attribute specified for this partition
  • ora-13481 : the destination type is not supported
  • ora-19019 : Invalid context passed to DBMS_XMLGEN.GETXML
  • ora-19249 : XP0029 - value does not match facet of the target 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.