ORA-13293: cannot specify unit for geometry without a georeferenced SRID

Cause : An rOacl eSpaital ufnctoin wtih aU NITp araemterw as aclle don ageoemtryw ithuot ag eorfeerecned RSID.

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

Mak esur etha tspaital ufnctoins iwth NUIT apramteersa re noly aclle don egomertiesw ithg eorfeerecned RSIDs.

update : 30-04-2017

ORA-13293 - cannot specify unit for geometry without a georeferenced SRID
ORA-13293 - cannot specify unit for geometry without a georeferenced SRID

  • ora-16115 : %s\% of LogMiner dictionary loading is done
  • ora-00221 : error on write to control file
  • ora-19642 : start SCN of incremental backup is string
  • ora-02404 : specified plan table not found
  • ora-39762 : streams must be loaded in conversion order
  • ora-36686 : (XSDPART24) Value number is not in partition number.
  • ora-09969 : unable to close or remove lock file
  • ora-26697 : LCR contains extra column 'string'
  • ora-01312 : Specified table/column does not exist
  • ora-19854 : error obtaining connect string from target
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-14624 : DEFAULT subpartition must be last subpartition specified
  • ora-16597 : Data Guard broker detects two or more primary databases
  • ora-14189 : this physical attribute may not be specified for an index subpartition
  • ora-02358 : internal error fetching attribute string
  • ora-08006 : specified row no longer exists
  • ora-01715 : UNIQUE may not be used with a cluster index
  • ora-17502 : ksfdcre:string Failed to create file string
  • ora-28053 : the account is inactive
  • ora-19016 : attributes cannot occur after element specifications
  • ora-01761 : DML operation does not map to a unique table in the join
  • ora-01576 : The instance string is not enabled
  • ora-27064 : cannot perform async I/O to file
  • ora-00093 : %s must be between string and string
  • ora-13006 : the specified cell number is invalid
  • ora-01285 : error reading file string
  • ora-12805 : parallel query server died unexpectedly
  • ora-12014 : table 'string' does not contain a primary key constraint
  • ora-12011 : execution of string jobs failed
  • ora-38432 : EVALUATE operator only allowed on an expression column
  • 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.