AnsweredAssumed Answered

Cannot Create SDE View 10.4.1

Question asked by mgmccart on Oct 3, 2016
Latest reply on Oct 3, 2016 by mgmccart

I am trying to create a view in our Oracle 12C SDE instance. I've tried a Python script, the Create View Tool in ArcCatalog and CREATE NEW>View by right-clicking in ArcCatalog and I get the following errors:

 

ORA-00928: missing SELECT keyword

ORA -00942: table or view does not exist. DBMS table not found

 

We are using ArcGIS 10.4.1 and SDE 10.4.1 on an Oracle 12C instance. Our geometry type is ST_Geometry. The view I am trying to create has point geometry. The script I am using inside the 'CREATE NEW>VIEW' in ArcCatalog is:

CREATE VIEW REALTIME_CRUMB_V55
AS SELECT (OBJECTID, LABEL, LOGDT, SHAPE)
FROM schemaowner.TRUCK_HISTORY_3HR
WHERE OBJECTID > 0;

 

I am logged in as 'schemaowner' when I try to create the view so I know there's not a privilege issue. I've also confirmed that the 'schemaowner' has 'CREATE_VIEW' privilege granted to it. I've also confirmed that our st_shapelib.dll file and path are confirmed correct in Oracle.

 

Any suggestions?

 

Thanks,
Mark

Outcomes