Does anyone know if I need to use ESRI's Create Spatial Type functionality when creating a field in a non ESRI / non geodatabase Oracle 11g database?
I have an older customer database in Oracle. After enabling the datatype ST_GEOMETRY on the database via Oracle's Locator functionality, I added a column to an existing table and populated each row as a point with relevant x,y & ,srid values.
However, ArcGIS v10.2.1 does not even recognize the column as a valid datatype. It labels it "unknown" in ArcCatalog and returns invalid data type when trying to build a query layer.
Would this indicate I need to use ESRI's Create Spatial Type in order to get ArcGIS to recognize the dataype/column in this non-geodatabase?
If so, can someone explain what it is doing that simply enabling the datatype directly in ORACLE does not?
Any theories as to why ArcGIS will not recognize this ST_GEOMETRY datatype?!