topic Re: Wrong Column Type in Data Management Questions

Wrong Column Type

BerkUlupinar — Mon, 17 Feb 2014 10:46:43 GMT

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.

Re: Wrong Column Type

VinceAngelo — Thu, 31 Jul 2025 14:32:40 GMT

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 exact 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

Re: Wrong Column Type

EmadAl-Mousa — Thu, 27 Feb 2014 02:32:52 GMT

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

Re: Wrong Column Type

VinceAngelo — Thu, 27 Feb 2014 03:34:31 GMT

No, with Query Layers, ArcSDE registration is no longer required. -V