nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cannot Create SDE View 10.4.1

MarkMcCart

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

Encontre mais publicações marcadas com

Accepted answers

Christian_Wells

This simple select works for me:

EDIT: This is from the New > View context menu. However, the GP tools works with the same inputs for me.

All comments

MarkMcCart

Thanks! That worked.

Christian_Wells

This simple select works for me:

EDIT: This is from the New > View context menu. However, the GP tools works with the same inputs for me.

MarkMcCart

I was able to make the view using Toad, so there must be some syntax issue with the way I am using the 'Create View' tool in catalog. Can anyone give me a working example on how to create a view with that tool?

MarkMcCart

I tried removing the semicolon in the Create View tool like this:

And it threw the following Errors:

ORA-00936: missing expression - DBMS table not found

ORA-04043: object schemaowner.REALTIME_CRUMBS does not exist.

Christian_Wells

When creating views using the Create View tool, only the select statement needs to be passed. The semi-colon is also going to throw an error and needs to be removed.

For example, just try this part:

SELECT (OBJECTID, LABEL, LOGDT, SHAPE)
FROM schemaowner.TRUCK_HISTORY_3HR
WHERE OBJECTID > 0

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.