ORA-13022: polygon crosses itself

Cause : The coordinates defining a polygonal geometric element represent crossing segments.

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

Redefine coordinates for the polygon.

update : 17-08-2017
ORA-13022

ORA-13022 - polygon crosses itself
ORA-13022 - polygon crosses itself

  • ora-00106 : cannot startup/shutdown database when connected to a dispatcher
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-07247 : skgfrfms, skgfrnms: read error, unable to read block from database file
  • ora-09978 : skxfqhdel: Error Disconnecting from another endpoint.
  • ora-24004 : invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
  • ora-30446 : valid workload queries not found
  • ora-08321 : scnmin: NOT IMPLEMENTED YET
  • ora-36842 : (XSLMGEN12) Hierarchy string.string!string.string was not found
  • ora-03283 : specified datafile string does not exist
  • ora-27200 : skgfpgo: sbtpcstart returned error
  • ora-01206 : file is not part of this database - wrong database id
  • ora-12170 : TNS:Connect timeout occurred
  • ora-24063 : cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
  • ora-00346 : log member marked as STALE
  • ora-14631 : the partition bounds do not match the subpartition bounds of the partition
  • ora-19114 : error during parsing the XQuery expression: string
  • ora-19590 : conversation already active
  • ora-22342 : dependent VARRAY column exceeds the maximum inline column size
  • ora-08454 : more than one S symbol specified in picture mask
  • ora-12029 : LOB columns may not be used as filter columns
  • ora-26004 : Tables loaded through the direct path may not be clustered
  • ora-27040 : file create error, unable to create file
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-09969 : unable to close or remove lock file
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-31676 : illegal value for number of workers, string
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-29952 : cannot issue DDL on a domain index partition marked as LOADING
  • ora-29347 : Tablespace name validation failed - failed to match tablespace 'string'
  • ora-38438 : getVarchar not possible due to "string" datatype in the attribute set
  • 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.