ORA-13265: geometry identifier column string in table string is not of type NUMBER

Cause : GID column is not of type NUMBER.

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

Alter the table definition such that the column containing the geometry identifier (GID) is of type NUMBER.

update : 18-08-2017
ORA-13265

ORA-13265 - geometry identifier column string in table string is not of type NUMBER
ORA-13265 - geometry identifier column string in table string is not of type NUMBER

  • ora-13116 : [string]_FACE$ table does not exist
  • ora-30748 : column string already enabled to store objects of type string.string
  • ora-04081 : trigger 'string' already exists
  • ora-09919 : Unable to set label of dedicated server
  • ora-22873 : primary key not specified for primary key based object table
  • ora-36964 : (XSRELTBL09) workspace object is not a valid level relation.
  • ora-02076 : sequence not co-located with updated table or long column
  • ora-40002 : wordsize must be string or greater
  • ora-02300 : invalid value for OIDGENERATORS
  • ora-28540 : internal result set error
  • ora-12629 : TNS:no event test
  • ora-12219 : TNS:missing community name from address in ADDRESS_LIST
  • ora-22613 : buflen does not match the size of the scalar
  • ora-12600 : TNS: string open failed
  • ora-32102 : invalid OCI handle
  • ora-25326 : Array string operation failed for message at index string
  • ora-28105 : cannot create security relevant column policy in an object view
  • ora-06255 : NETNTT: cannot read pid of remote process
  • ora-30066 : test support - drop rollback segment wait
  • ora-01616 : instance string (thread string) is open - cannot disable
  • ora-25233 : invalid parameter specified for NAVIGATION
  • ora-27478 : job "string.string" is running
  • ora-00288 : to continue recovery type ALTER DATABASE RECOVER CONTINUE
  • ora-29903 : error in executing ODCIIndexFetch() routine
  • ora-02030 : can only select from fixed tables/views
  • ora-12850 : Could not allocate slaves on all specified instances: string needed, string allocated
  • ora-32166 : Cannot get XA connection
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-02381 : cannot drop PUBLIC_DEFAULT profile
  • ora-30729 : maximum number of columns exceeded
  • 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.