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

Can you add ArcSDE to an existing non geo-spatial Oracle database?

CesarDuran3

We have an existing system with a non spatial database in Oracle and we want to add spatial capabilities to this system.

Should we keep separated spatial and non spatial databases?

Is there a way to add ArcSDE to an existing non-spatial database?

What are the common architecture in these cases?

Thank you!!!

Find more posts tagged with

Accepted answers

George_Thompson

You can add the Enterprise Geodatabase (EGDB) portion to your existing Oracle DB. All the contents will be held in a different schema within Oracle. You can also create a separate new Oracle DB for the EGDB, it really depends on the what the DBA's prefer and space available.

Here is some documentation to get you started with Oracle and the EGDB: Geodatabases in Oracle—Help | ArcGIS Desktop

https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=6d7c6ee8-b99b-4c0a-a91d-3b62f779d544&searchIndex=1‌ https://community.esri.com/groups/enterprise-architect?sr=search&searchId=727b25f2-2af5-45f3-a00c-8d53fafe7720&searchIndex=2‌ ‌

All comments

George_Thompson

Here is some documentation to get you started with Oracle and the EGDB: Geodatabases in Oracle—Help | ArcGIS Desktop

AdamZiegler1

You can also just add the ST_GEOMETRY data type to enable the database with spatial capabilities. You would need to manage the spatial data with ST_GEOMETRY functions, and this would be simple geometry storage...no topology, networks, domains, etc. The advanced GDB functionality requires full Enterprise GDB, simple spatial functionality can be accomplished with adding ST_GEOMETRY. This could also be stored in a separate SDE schema and managed separately from business data.

Add the ST_Geometry type to an Oracle database—Help | ArcGIS Desktop

Adam Z

JoshuaBixby

Or even use Oracle's native spatial data type(s): Spatial Data Types and Metadata .

When you state "add spatial capabilities to this system," it is a seemingly simple question that has more answers than you can imagine. If this is you or your organization's first foray into working with spatial data, I recommend working with an enterprise architect and business analyst to understand and document your requirements in a way that an IT shop or service provider can implement successfully.

CesarDuran3

Thank you George, this is very helpful!

CesarDuran3

Wow! thank you Adam, I didn't know that. This is probably a great solution for some of hour tables.

CesarDuran3

Thank you Joshua, I agree with you. We were trying to know what are the possibilities to create the documentation. Thank you for you help.

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.