Wrong Column Type

328
3
02-17-2014 02:46 AM
BerkUlupinar
New Contributor II
Hello,

I created a tablespace and a table into this tablespace in oracle spatial. (11g) After that,i connect this database from ArcCatalog.When i want to add this table to table of contents, ArcGIS gives me a warning : "Could not add specified data ojbect to the map.Wrong Column Type(ınvalid geometry storage type)"

How can i solve this problem?
Thanks for helping.
0 Kudos
3 Replies
VinceAngelo
Esri Esteemed Contributor
You could help yourself by providing the information necessary to answer your question:

  • Which exact Oracle release are you using (11.x.y.z)?

  • What excat version (and service pack) of ArcGIS are you using?

  • Have you enabled a geodatabase in the instance, or are you using a Query Layer?

  • How exactly is the table defined? (Provide SQL*Plus DESCRIBE output or your

  • CREATE TABLE command)
  • How have you populated the SDO_GEOM_METADATA table row associated with

  • this table?
  • Have you built an index on the geometry column?  If so, what exact command

  • did you use to build it?
  • Which column did you specify as the rowid column?

  • Are all the non-nil geometries in the table either point, multi-point, line, or area features?


Note that "Oracle Spatial" is not a storage format -- It's an application suite.  The storage
format is SDO_GEOMETRY.

- V
0 Kudos
EmadAl-Mousa
Occasional Contributor III
you need to register the oracle spatial layer with SDE Geodatabase.

check this as a refrence: http://support.esri.com/cn/knowledgebase/techarticles/detail/20275
0 Kudos
VinceAngelo
Esri Esteemed Contributor
No, with Query Layers, ArcSDE registration is no longer required. -V
0 Kudos