topic Re: Database mangement in Oracle in Data Management Questions

Database mangement in Oracle

ShahidHussain — Sun, 14 Feb 2016 15:51:08 GMT

Hi, I want to know the best practice to manage geospatial databases in oracle 11g. My question is if an organization consist of different departments having different geodatabases like geographical names, 1:25k topographical geodatabase, hydrographic grodatabase etc. how to mange these databases in Oracle

1- create a organization database and add all department schema's in it. In this way we have one database with multiple schema's. Is this the way to create an Enterprise Oracle Geodatabase?

2- the other way to keep different database separately in Oracle?

3- what's the best option to work in a multiuser versioning environment?

thanks

Re: Database mangement in Oracle

DanPatterson_Retired — Sun, 14 Feb 2016 17:51:13 GMT

the system etc requirements are here...

Set up a geodatabase in Oracle—Help | ArcGIS for Desktop

Oracle database requirements for ArcGIS 10.4—Help | ArcGIS for Desktop

then there is the workflow manager

Introduction to storing the Workflow Manager workspace in a geodatabase in Oracle—Help | ArcGIS for Desktop

Did you see any of these?

Re: Database mangement in Oracle

ShahidHussain — Sun, 14 Feb 2016 18:20:07 GMT

Hi Dan Patterson,

Thanks your links are very helpful, what I understand if we want to create an organization combinded geodatabase we have to create masrer sde geodatabase Which contains different geodatabases.

Is this is good for working in a multiuser versioning environment?

Re: Database mangement in Oracle

DanPatterson_Retired — Sun, 14 Feb 2016 18:26:01 GMT

Decisions would be yours, but I would recommend getting esri involved before you waste money hoping you get it right. Suggests from others may be useful, but a face-to-face where questions and answers can be addressed immediately will cost you nothing.

Types of geodatabases—ArcGIS Help | ArcGIS for Desktop

The whole sections on database, management etc would have to be considered as well as the types of work and workflows you are involved in.