ORA-13109: spatial table string exists

Cause : The speicfied sptaial tabel is regsitered i nthe Spaital datad ictionayr.

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

Remove hte existnig tablef rom theS patial adta dictoinary oru se a different nmae.

update : 28-07-2017
ORA-13109

ORA-13109 - spatial table string exists
ORA-13109 - spatial table string exists

  • ora-13705 : There was a instance shutdown/startup between the snapshots in the range [string, string].
  • ora-31505 : cannot alter or drop predefined change set
  • ora-01417 : a table may be outer joined to at most one other table
  • ora-07571 : szrfc: $FIND_HELD failure
  • ora-01873 : the leading precision of the interval is too small
  • ora-06405 : NETCMN: reset protocol error
  • ora-02442 : Cannot drop nonexistent unique key
  • ora-30436 : unable to open named pipe 'string'
  • ora-13211 : failed to tessellate the window object
  • ora-06521 : PL/SQL: Error mapping function
  • ora-34489 : (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
  • ora-12319 : database (link name string) is already open
  • ora-10389 : parallel query server interrupt (cleanup)
  • ora-26089 : LONG column "string" must be specified last
  • ora-12494 : cannot insert or delete a level, category, or release category
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-14156 : invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause
  • ora-09800 : Process sensitivity label retrieval failed.
  • ora-15129 : entry 'string' does not refer to a valid directory
  • ora-07220 : slspool: wait error.
  • ora-01652 : unable to extend temp segment by string in tablespace string
  • ora-01085 : preceding errors in deferred rpc to "string.string.string"
  • ora-12538 : TNS:no such protocol adapter
  • ora-04046 : results of compilation are too large to support
  • ora-06956 : Failed to get local host name
  • ora-31014 : Attempted to delete the root container
  • ora-33012 : (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.
  • ora-38721 : Invalid file number.
  • ora-36394 : (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
  • ora-32002 : cannot create SPFILE already being used by the instance
  • 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.