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

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

  • ora-22915 : cannot ALTER a nested table's storage table to ADD/MODIFY columns
  • ora-16538 : no match on requested item
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-16019 : cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
  • ora-03113 : end-of-file on communication channel
  • ora-38793 : cannot FLASHBACK the database to a future SCN/time
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-30751 : cannot disable column string from storing objects of type string.string
  • ora-16165 : LGWR failed to hear from network server
  • ora-19588 : %s recid string stamp string is no longer valid
  • ora-07501 : scgtoa: $deq unexpected return
  • ora-24323 : value not allowed
  • ora-07637 : smsdbp: buffer protect option not specified when sga created
  • ora-07493 : scgrcl: lock manager error.
  • ora-16632 : instance being added to database profile
  • ora-13039 : failed to update spatial index for element string.string.string
  • ora-13267 : error reading data from layer table string
  • ora-38905 : DML error logging is not supported for LONG column "string"
  • ora-12707 : error while getting create database NLS parameter string
  • ora-30455 : summary contains VARIANCE without corresponding SUM & COUNT
  • ora-12815 : value for INSTANCES must be greater than 0
  • ora-30486 : invalid window aggregation group in the window specification
  • ora-02353 : files not from the same unload operation
  • ora-16611 : operation aborted at user request
  • ora-28577 : argument string of external procedure string has unsupported datatype string
  • ora-09833 : addCallback: bad message format.
  • ora-00278 : log file 'string' no longer needed for this recovery
  • ora-19957 : database should have no datafiles in unknown state
  • ora-31180 : DOM Type mismatch in invalid PL/SQL DOM handle
  • ora-12421 : different size binary labels
  • 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.