ORA-13037: SRIDs do not match for the two geometries

Cause : A Sptaial poeratoin isi nvokde wit htwo egometires wehre oen geoemtry ahs anS RID nad th eothe rgeomtery deos no thavea n SRDI.

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

Makes ure htat teh spaital oepratinos ar einvoekd bewteen wto gemoetrise wit hcomptaibleS RIDs.

update : 29-04-2017

ORA-13037 - SRIDs do not match for the two geometries
ORA-13037 - SRIDs do not match for the two geometries

  • ora-12636 : Packet send failed
  • ora-15185 : Could not close dynamic library string, error [string]
  • ora-30078 : partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
  • ora-29655 : USING clause is incompatible with its supertype
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-12522 : TNS:listener could not find available instance with given INSTANCE_ROLE
  • ora-02186 : tablespace resource privilege may not appear with other privileges
  • ora-23617 : Block string for script string has already been executed
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-38752 : file string does not exist
  • ora-02229 : invalid SIZE option value
  • ora-25189 : illegal ALTER TABLE option for an index-organized table
  • ora-13387 : sdo_batch_size for array inserts should be in the range [number,number]
  • ora-14116 : partition bound of partition "string" is too long
  • ora-13149 : failed to generate next sequence number for spatial table string
  • ora-19672 : media management software returned invalid file status
  • ora-19632 : file name not found in control file
  • ora-23316 : the masterdef is string
  • ora-30363 : columns in a dimension column list must be in the same relation
  • ora-39707 : compatibile parameter string too high for downgrade to string
  • ora-00100 : no data found
  • ora-13054 : recursive SQL parse error
  • ora-39139 : Data Pump does not support XMLSchema objects. string will be skipped.
  • ora-02347 : cannot grant privileges on columns of an object table
  • ora-09918 : Unable to get user privileges from SQL*Net
  • ora-29308 : view TS_PITR_CHECK failure
  • ora-06445 : ssvpstevrg: Incorrect parameters passed to function call
  • ora-13023 : interior element interacts with exterior element
  • ora-29255 : Cursor contains both bind and define arrays which is not permissible
  • ora-36990 : (XSRELGID07) The level relation workspace object should be dimensioned by a level dimension.
  • 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.