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

Geodatabase Enterprise

DEVAPP

Hi guys,

i have a oracle database that contain all data with SDO_GEOMTRY.

And i see that with arcgis 10.3 i can connect this and works very well but i this way i'm working with native oracle format.

Instead if i have a ArcGIS Server i can create a geodatabase Enterprise on this oracle database.

I would like to know the difference or limitation if i works in native oracle format instead into geodatabase enterprise.

There is some link to see? Some Document?

Any help it's great

Thanks

Find more posts tagged with

Accepted answers

George Thompson

DEV APP,

Here is some more information specifically with geodatabases on Oracle:

-Geodatabase data can be edited in ArcMap but database data cannot.

Geodatabases in Oracle—Help | ArcGIS for Desktop

Databases and ArcGIS—Help | ArcGIS for Desktop

What is a feature service?—Documentation (10.3 and 10.3.1) | ArcGIS for Server

Author feature services—Documentation (10.3 and 10.3.1) | ArcGIS for Server

Tutorial: Perform web editing using data from a database—Documentation (10.3 and 10.3.1) | ArcGIS for Server

Here is a great blog with some more information: The Evolution of Query Layers | Support Services Blog

Hope this helps!

George

Managing Data Enterprise GIS

All comments

DEVAPP

Hi George,

thanks for your response.

Reading this links i see that my thoughts were right.

If my oracle it's not registered as Geodatabase Enterprise (Create Geodatabase Enterprise Geoprocessing tool) i can't publish feature service, i can't edit my data by arcmap but i can edit it by oracle, i can't use some relation 1 - m if is stored into oracle and so i can't use this into map service when i publish a mxd.

Right?

Thanks

DEVAPP

I'm using the Add Database connection

George Thompson

DEV APP,

Here is some more information specifically with geodatabases on Oracle:

-Geodatabase data can be edited in ArcMap but database data cannot.

Geodatabases in Oracle—Help | ArcGIS for Desktop

Databases and ArcGIS—Help | ArcGIS for Desktop

What is a feature service?—Documentation (10.3 and 10.3.1) | ArcGIS for Server

Author feature services—Documentation (10.3 and 10.3.1) | ArcGIS for Server

Tutorial: Perform web editing using data from a database—Documentation (10.3 and 10.3.1) | ArcGIS for Server

Here is a great blog with some more information: The Evolution of Query Layers | Support Services Blog

Hope this helps!

George

Managing Data Enterprise GIS

Anonymous User

I suppose you are using query layers for accessing third party spatial tables from ArcMap. If "yes", take a look at this post:

The Evolution of Query Layers | Support Services Blog

Regards

Jesús de Dego

DEVAPP

Thanks for your reply, but if i works with oracle data type without Geodatabase Enterprise i have some limitation about publish data? Example i can publish a feature service if my data it's on oracle and not into Geodatabase Enterprise? or i suppose that i can't use into map service the relation 1 to M if this relation is on oracle?

Thanks

QuinnFrancis

The link below provides some useful information on Oracle data types supported in ArcGIS

Oracle data types supported in ArcGIS—Help | ArcGIS for Desktop

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.