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 : 27-06-2017
ORA-13293

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

  • ora-14068 : TABLESPACE and TABLESPACE_NUMBER may not be both specified
  • ora-16175 : cannot shut down database when media recovery is active
  • ora-02270 : no matching unique or primary key for this column-list
  • ora-22629 : OCIAnyData is null
  • ora-23452 : flavor string of object group "string"."string" is already published
  • ora-12497 : maximum combined categories exceeds string
  • ora-00351 : recover-to time invalid
  • ora-07845 : sllfcl: LIB$FREE_VM failue
  • ora-36850 : (XSLMGEN20) View token string is not correct
  • ora-34481 : (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.
  • ora-24431 : Statement does not exist in the cache
  • ora-19632 : file name not found in control file
  • ora-14314 : resulting List partition(s) must contain atleast 1 value
  • ora-29851 : cannot build a domain index on more than one column
  • ora-29328 : too many datafiles in this tablespace 'string'
  • ora-30185 : output too large to fit in the buffer
  • ora-00299 : must use file-level media recovery on data file string
  • ora-00343 : too many errors, log member closed
  • ora-01208 : data file is an old version - not accessing current version
  • ora-24021 : queue table definition not imported for string.string
  • ora-01286 : start interval required
  • ora-12540 : TNS:internal limit restriction exceeded
  • ora-15117 : command only operates on one diskgroup
  • ora-19201 : Datatype not supported
  • ora-12027 : duplicate filter column
  • ora-10562 : Error occurred while applying redo to data block (file# string, block# string)
  • ora-24281 : invalid access past the maximum size of LOB parameter string
  • ora-32800 : internal error string
  • ora-17507 : I/O request size string is not a multiple of logical block size
  • ora-24326 : handle passed in is already 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.