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; } } }

What is the difference between adding a view directly in Oracle and using arcpy.CreateDatabaseView_management?

DeanHowell1

If I need to create database views on spatial layers, it is better to add them directly in Oracle using create view function or using python using the arcpy.CreateDatabaseView_management function?

Is there any difference in performance, the way they function etc?

Find more posts tagged with

Accepted answers

Asrujit_SenGupta

It is the same thing.

Create a database view in ArcGIS Desktop—Help | ArcGIS Desktop mentions the below:

Be aware that no matter which method you use, the view is a database view; even if it is created in an enterprise geodatabase, it is not a geodatabase object until you register it with the geodatabase.

All comments

DeanHowell1

Thanks Asrujit, previously written SDE command line tools, working in oracle 11g, have stopped working since we upgraded to Oracle 12c and ArcGIS 10.3. The business has no immediate intention to upgrade to 10.5 as there is too much integration dependant on the 10.3 installation.

Asrujit_SenGupta

Use the tool Register with Geodatabase—Help | ArcGIS Desktop which is available from Desktop 10.5 or check this link FAQ: Can ArcSDE command line tools be used against 10.3 and newer geodatabases?

DeanHowell1

How do you register the view with the geodatabase when using ArcGIS 10.3 and Oracle 12c?

DeanHowell1

Thanks Asrujit and thanks for the tip regarding registering it as that was the step I was missing

Asrujit_SenGupta

It is the same thing.

Create a database view in ArcGIS Desktop—Help | ArcGIS Desktop mentions the below:

Be aware that no matter which method you use, the view is a database view; even if it is created in an enterprise geodatabase, it is not a geodatabase object until you register it with the geodatabase.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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