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

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

  • ora-25145 : allocation policy already specified
  • ora-16025 : parameter string contains repeated or conflicting attributes
  • ora-30680 : debugger connection handshake failed
  • ora-25252 : listen failed, the address string is a non-persistent queue
  • ora-19558 : error de-allocating device
  • ora-28337 : the specified index may not be defined on an encrypted column
  • ora-14609 : Tablespace was not specified for the previous lob segments of column string in template but is specified for string
  • ora-09788 : sllfrb: unable to read file.
  • ora-12834 : Instance group name, 'string', too long, must be less than string characters
  • ora-24807 : LOB form mismatch
  • ora-36341 : (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)
  • ora-29314 : tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY
  • ora-19688 : control file autobackup format(string) for string does not have %F
  • ora-13642 : The specified string string provided for string cannot be converted to a date. The acceptable date format is string.
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-21520 : database server driver not installed
  • ora-19729 : File string is not the initial version of the plugged in datafile
  • ora-00113 : protocol name string is too long
  • ora-24362 : improper use of the character count flag
  • ora-01317 : Not attached to a Logminer session
  • ora-14309 : Total count of list values exceeds maximum allowed
  • ora-34722 : (NLSCHARSET05) CAUTION: Character data loss in character set conversion from string to string
  • ora-01424 : missing or illegal character following the escape character
  • ora-31075 : invalid string declaration in XML Schema
  • ora-19678 : RMAN configuration value exceeds maximum length of string
  • ora-24096 : invalid message state specified
  • ora-19999 : skip_row procedure was called
  • ora-00040 : active time limit exceeded - call aborted
  • ora-00038 : Cannot create session: server group belongs to another user
  • ora-13443 : GeoRaster metadata SRS error
  • 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.