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 : 25-06-2017

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

  • ora-03262 : the file is non-empty
  • ora-13285 : Geometry coordinate transformation error
  • ora-31495 : error in synchronous change table on "string"."string"
  • ora-29967 : Cannot drop an operator binding with dependent objects
  • ora-07267 : spwat: invalid process number.
  • ora-02091 : transaction rolled back
  • ora-39778 : the parallel load option is not allowed when loading lob columns
  • ora-38908 : internal error occurred during DML Error Logging
  • ora-23290 : This operation may not be combined with any other operation
  • ora-36908 : (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.
  • ora-09807 : Conversion of label from string to binary failed.
  • ora-01743 : only pure functions can be indexed
  • ora-24131 : table string has incorrect columns
  • ora-16159 : Cannot change protected standby destination attributes
  • ora-38711 : Corrupt flashback log block header: block string
  • ora-12665 : NLS string open failed
  • ora-07254 : spdcr: translation error while expanding ?/bin/oracle.
  • ora-01413 : illegal value in packed decimal number buffer
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-14270 : table is not partitioned by Range or Hash or List method
  • ora-08340 : This command not allowed on nCUBE, only one thread is ever used.
  • ora-16050 : destination exceeded specified quota size
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-28155 : user 'string' specified as a proxy is actually a role
  • ora-10659 : Segment being shrunk is not a lob
  • ora-19623 : file string is open
  • ora-31658 : specifying a schema name requires a table name
  • ora-28111 : insufficient privilege to evaluate policy predicate
  • ora-26535 : %ud byte row cache insufficient for table with rowsize=number
  • ora-19656 : cannot backup, copy, or delete online log 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.