ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA

Cause : A tolerance of zero or NULL is supplied for a layer in USER_SDO_GEOM_METADATA view.

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

Check the tolerance specified to make sure it is a positive value.

update : 23-08-2017

ORA-13224 - zero tolerance specified for layer in USER_SDO_GEOM_METADATA
ORA-13224 - zero tolerance specified for layer in USER_SDO_GEOM_METADATA

  • ora-14119 : specified partition bound is too long
  • ora-36875 : (XSTFDSC05) LIMITMAP is missing or is not a string literal.
  • ora-35756 : (VCTODT02) 'number' is not a valid date because number is out of range for a year.
  • ora-13528 : name (string) is already used by an existing baseline
  • ora-29346 : invalid tablespace list
  • ora-02314 : illegal use of type constructor
  • ora-02470 : TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.
  • ora-32700 : error occurred in DIAG Group Service
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-01162 : block size string in file header does not match configured block sizes
  • ora-16240 : Waiting for logfile (thread# string, sequence# string)
  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-02068 : following severe error from stringstring
  • ora-16747 : logical standby database guard could not be turned on
  • ora-13527 : invalid baseline name
  • ora-13110 : cannot drop topology with associated topo_geometry tables
  • ora-19612 : datafile string not restored due to string
  • ora-31185 : DOM Nodes do not belong to the same DOM Document
  • ora-06439 : ssaio: the asynchronous write returned incorrect number of bytes
  • ora-36274 : (XSCGMDLAGG05) The operator used in this equation needs a weight variable.
  • ora-27456 : not all arguments of program "string.string" have been defined
  • ora-02855 : Number of requests is less than the number of slaves
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-13291 : conversion error between the specified unit and standard unit
  • ora-02834 : Server unable to open file
  • ora-26699 : STREAMS message consumer string already exists
  • ora-25156 : old style outer join (+) cannot be used with ANSI joins
  • ora-28519 : no heterogeneous data dictionary translations available
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-13768 : Snapshot ID must be between string and string.
  • 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.