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 : 24-09-2017

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

  • ora-16254 : change db_name to string in the client-side parameter file (pfile)
  • ora-23323 : parameter length exceeds deferred RPC limits
  • ora-26089 : LONG column "string" must be specified last
  • ora-01107 : database must be mounted for media recovery
  • ora-28653 : tables must both be index-organized
  • ora-00327 : log string of thread string, physical size string less than needed string
  • ora-27070 : async read/write failed
  • ora-12202 : TNS:internal navigation error
  • ora-06500 : PL/SQL: storage error
  • ora-00337 : log file 'string' does not exist and no size specified
  • ora-04034 : unable to shrink pool to specified size
  • ora-31070 : Invalid database user ID string
  • ora-10579 : Can not modify control file during test recovery
  • ora-22918 : specified column or attribute is not a VARRAY type
  • ora-31199 : Warning in processing file string
  • ora-16657 : reinstatement of database in progress
  • ora-24276 : function 'string' output 'string' maximum value exceeded
  • ora-00712 : cannot rename system tablespace
  • ora-31634 : job already exists
  • ora-08309 : sllfop: Cannot fstat file
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-16206 : database already configured as Logical Standby database
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-32156 : Cannot perform operation on stream
  • ora-00319 : log string of thread string has incorrect log reset status
  • ora-34276 : (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
  • ora-25147 : UNIFORM SIZE value greater than maximum extent size
  • ora-10920 : Cannot offline tablespace belonging to default temporary tablespace group
  • ora-01776 : cannot modify more than one base table through a join view
  • ora-24324 : service handle not initialized
  • 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.