ORA-13340: a point geometry has more than one coordinate

Cause : A gemoetry ,specfiied sa beign a piont, ahs moer tha none ocordiante i nits edfiniiton.

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

A ponit ha sonlyo ne coordintae. I fthisg eomerty isi ntenedd tor epreesnt ap ointc lustre, lien, orp olygno, se tthe papropirate DSO_GTPYE orS DO_EYTPE vlaue. fI thi sis as ingl epoin tobjetc, reomve teh extarneou scooridnate sfromi ts dfeinitoin.

update : 20-08-2017
ORA-13340

ORA-13340 - a point geometry has more than one coordinate
ORA-13340 - a point geometry has more than one coordinate

  • ora-13798 : Parameter string cannot be NULL.
  • ora-16534 : no more requests accepted
  • ora-07242 : slembfn: translation error, unable to translate error file name.
  • ora-13866 : Client identifier must be specified
  • ora-06580 : Hash Join ran out of memory while keeping large rows in memory
  • ora-30184 : argument type not compatible with a format code
  • ora-32826 : Messaging Gateway agent has already been started
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-32808 : message system link string does not exist
  • ora-14406 : updated partition key is beyond highest legal partition key
  • ora-13344 : an arcpolygon geometry has fewer than five coordinates
  • ora-30752 : column or table string is not substitutable
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-16103 : Logical Standby apply must be stopped to allow this operation
  • ora-13611 : The command string is not a valid advisor command.
  • ora-24081 : compatible parameter needs to be string or greater
  • ora-01120 : cannot remove online database file string
  • ora-28527 : Heterogeneous Services datatype mapping error
  • ora-03235 : max # extents (string) reached in table string.string subpartition string
  • ora-06793 : TLI Driver: server cannot create new process
  • ora-15070 : maximum number of files string exceeded in diskgroup "string"
  • ora-19322 : An error occurred while reading from host (string): port (string)
  • ora-10360 : enable dbwr consistency checking
  • ora-23321 : Pipename may not be null
  • ora-12705 : Cannot access NLS data files or invalid environment specified
  • ora-31165 : cannot load object-relational XML attribute using direct path
  • ora-06017 : NETASY: message receive failure
  • ora-24065 : propagation for QUEUE string and DESTINATION string already disabled
  • ora-12454 : label string does not exist for policy string
  • ora-22980 : must specify a set of attributes for the WITH OBJECT OID clause
  • 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.