Oracle SDO table view not showing in arcmap

Hcemince — Mon, 27 Dec 2021 13:29:05 GMT

Hello ,

I am trying to create view table based on a sdo spatial table from our database. When i create the view, arcmap doesn't draw the points.

CREATE OR REPLACE VIEW "GIS"."VIEWTEST1" AS
SELECT CAST (ROWNUM AS NUMBER (7))OBJECTID , o.ID , o.FAULT_CODE AS ARIZANO, o.FAULT_TYPE_ID AS ARIZATIPI ,o.QUARTER_STREET_ID AS CSBMKOD ,o.FAULT_DATE AS KAYITTARIHI, SYS_GUID() AS ESRI_OID,
SDO_GEOMETRY (
o.LOCATION.SDO_GTYPE,
5254,
NULL,
o.LOCATION.SDO_ELEM_INFO,
o.LOCATION.SDO_ORDINATES
)SHAPE
FROM TEST.OPR_FAULT_NOTIFY o
WHERE o.WORK_FINISH_DATE IS NULL

topic Oracle SDO table view not showing in arcmap in Data Management Questions

Oracle SDO table view not showing in arcmap