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

653
6
Jump to solution
12-11-2017 12:34 PM
CesarDuran3
New Contributor II

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!!!

0 Kudos
1 Solution

Accepted Solutions
George_Thompson
Esri Frequent Contributor

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-3...https://community.esri.com/groups/enterprise-architect?sr=search&searchId=727b25f2-2af5-45f3-a00c-8d...

--- George T.

View solution in original post

6 Replies
George_Thompson
Esri Frequent Contributor

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-3...https://community.esri.com/groups/enterprise-architect?sr=search&searchId=727b25f2-2af5-45f3-a00c-8d...

--- George T.
CesarDuran3
New Contributor II

Thank you George, this is very helpful!

0 Kudos
AdamZiegler1
Esri Contributor

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

CesarDuran3
New Contributor II

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

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

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
New Contributor II

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.

0 Kudos