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 : 23-06-2017
ORA-13340

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

  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-19767 : missing TRACKING keyword
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-16195 : DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined
  • ora-06529 : Version mismatch - PL/SQL profiler
  • ora-23442 : object already exists for the refresh group template
  • ora-16606 : unable to find property "string"
  • ora-13017 : unrecognized line partition shape
  • ora-24021 : queue table definition not imported for string.string
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-29875 : failed in the execution of the ODCIINDEXINSERT routine
  • ora-13272 : geometric object string in table string is invalid
  • ora-02090 : network error: attempted callback+passthru
  • ora-40215 : model string is incompatible with current operation
  • ora-25321 : enqueue failed, user property specified but queue string.string is not an 8.1 style queue
  • ora-16145 : archival for thread# string sequence# string in progress
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-39142 : incompatible version number string in dump file "string"
  • ora-01102 : cannot mount database in EXCLUSIVE mode
  • ora-06042 : NETDNT: message receive failure
  • ora-12986 : columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE
  • ora-19570 : file number string is outside valid range of 1 through string
  • ora-30178 : duplicate flag used in a format specification
  • ora-07843 : sllfcl: LIB$FREE_VM failure
  • ora-13261 : geometry table string does not exist
  • ora-32008 : error while processing parameter update at instance string
  • ora-25466 : data not specified for variable name: string
  • ora-01921 : role name 'string' conflicts with another user or role name
  • ora-38951 : Target platform string not cross platform compliant
  • 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.