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 : 30-04-2017
ORA-13340

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

  • ora-02783 : Both post and wait functions were not specified
  • ora-07681 : sou2os: An error occurred while initializing Oracle
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-31669 : Worker process string violated startup protocol.
  • ora-07594 : spiip: $GETJPIW failure
  • ora-12433 : create trigger failed, policy not applied
  • ora-23465 : flavor already includes column string of "string"."string"
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • ora-30392 : the checksum analysis for the rewrite equivalence failed
  • ora-09795 : szrbuild: malloc of role structure failed.
  • ora-00478 : SMON process terminated due to error string
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-14299 : total number of partitions/subpartitions exceeds the maximum limit
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-16046 : Archive log destination failed due to failed dependent destination
  • ora-01561 : failed to remove all objects in the tablespace specified
  • ora-13203 : failed to read USER_SDO_GEOM_METADATA view
  • ora-00060 : deadlock detected while waiting for resource
  • ora-33298 : (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
  • ora-26730 : %s 'string' already exists
  • ora-37082 : Invalid percent
  • ora-22983 : not a user-defined REF
  • ora-27102 : out of memory
  • ora-22924 : snapshot too old
  • ora-01090 : shutdown in progress - connection is not permitted
  • ora-16808 : unable to resolve the full path name
  • ora-24171 : creation properties are only for internal use
  • ora-16192 : Primary and standby network integrity mismatch
  • ora-37011 : (XSACQUIRE_LOCKED) Object workspace object is locked by another user.
  • ora-13919 : Cannot specify values for parameter "string" and for parameter "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.