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 : 17-08-2017

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

  • ora-28667 : USING INDEX option not allowed for the primary key of an IOT
  • ora-02022 : remote statement has unoptimized view with remote object
  • ora-09362 : Windows 3.1 Two-Task driver unable to deallocate context area
  • ora-00372 : file string cannot be modified at this time
  • ora-00163 : internal database name length string is greater than maximum (string)
  • ora-01576 : The instance string is not enabled
  • ora-16221 : history table synchronization error
  • ora-29368 : consumer group string does not exist
  • ora-12720 : operation requires database is in EXCLUSIVE mode
  • ora-29339 : tablespace block size string does not match configured block sizes
  • ora-39077 : unable to subscribe agent string to queue "string"
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-31452 : invalid value string for parameter, expecting: Y or N
  • ora-36154 : (XSMXAGGR01) workspace object is not a data variable.
  • ora-00489 : ARB* process terminated with error
  • ora-37182 : you may only specify one dimension to partition
  • ora-02424 : potential circular view references or unknown referenced tables
  • ora-16027 : parameter string is missing a destination option
  • ora-27094 : raw volume used can damage partition table
  • ora-16741 : the destination parameter of standby database "string" has incorrect syntax
  • ora-09989 : attempt to use invalid skgmsdef struct pointer
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-23387 : replication parallel push dequeue error
  • ora-24239 : object could not be invalidated
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-06793 : TLI Driver: server cannot create new process
  • ora-13409 : null or invalid pyramidLevel parameter
  • ora-29913 : error in executing string callout
  • ora-39020 : invalid mode type string
  • ora-31408 : invalid value specified for begin_scn or end_scn
  • 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.