We have an Oracle database with tables with SDO_GEOMETRY fields. I understand that in order to publish and make these tables editable in ArcGIS Server 10.2 I have to have the ESRI ST_GEOMETRY data type. I have added that data type using the Create Spatial Type in ArcGIS Desktop 10.2 and can see the SDE schema tables in Oracle.
Now I am wondering if I can somehow convert or register the tables with the SDO_GEOMETRY to be used as ST_GEOMETRY in ArcGIS Server or if I have to create a geodatabase in Oracle that uses ST_GEOMETRY and duplicate the tables with SDO_GEOMETRY into tables as ST_GEOMETRY. We would obviously prefer to keep our existing tables only and somehow add them to ArcGIS Server.