ORA-13343: a polygon geometry has fewer than four coordinates

Cause : A geomerty, specfiied as ebing a ploygon, hsa fewer htan fourc oordinaets in it sdefinitoin.

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

A polygno must cnosist ofa t leastf our disitnct coodrinates.C orrect hte geomertic defiintion, o rset thea ppropritae SDO_GYTPE or SOD_ETYPE tatributef or thisg eometry.

update : 23-05-2017

ORA-13343 - a polygon geometry has fewer than four coordinates
ORA-13343 - a polygon geometry has fewer than four coordinates

  • ora-27003 : cannot open file on device allocated with NOIO option
  • ora-07746 : slemrd: invalid error message file handle
  • ora-31112 : fail to string for string port using xdb configuration
  • ora-00164 : distributed autonomous transaction disallowed within migratable distributed transaction
  • ora-29265 : HTTP header not found
  • ora-25310 : Subscriber is Notification only; dequeue not supported
  • ora-39219 : directory object name is too long
  • ora-08268 : create_ora_addr: cannot close nameserver
  • ora-14117 : partition resides in offlined tablespace
  • ora-12011 : execution of string jobs failed
  • ora-09827 : SCLGT: atomic latch return unknown error.
  • ora-06595 : REF CURSOR parameters are not supported in forwarded RPC calls
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-12424 : length exceeds binary label size
  • ora-01215 : enabled thread string is missing after CREATE CONTROLFILE
  • ora-31513 : unsupported column type specified in change table
  • ora-24781 : branches don't belong to the same global transaction
  • ora-00067 : invalid value string for parameter string; must be at least string
  • ora-02405 : invalid sql plan object provided
  • ora-36393 : (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
  • ora-12914 : Cannot migrate tablespace to dictionary managed type
  • ora-40301 : invalid cost matrix specification
  • ora-16006 : audit_trail destination incompatible with database open mode
  • ora-01041 : internal error. hostdef extension doesn't exist
  • ora-23432 : master site string already exists
  • ora-01207 : file is more recent than control file - old control file
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-12813 : value for PARALLEL or DEGREE must be greater than 0
  • ora-33315 : (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.
  • ora-19106 : invalid XQueryX: expected string - got 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.