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

Multiple geodatabase oracle

yockee

Hi,

I just want explanation and discussion.

When do we use such configuration like the picture below ? Are they different geodatabases or single geodatabase but split into 2 databases ?

Thanks

Vind meer berichten getagd met

Enterprise geodatabase

Databases

Accepted answers

George_Thompson

For which configuration?

If you have a need for a DEV / STAGE / PROD enterprise geodatabases, then you would create a new SID for each one.

You could have multiple data schemas in the same Oracle SID, i.e. GIS / WATER / SEWER / TRANS / etc.

George_Thompson

That used to be possible, but we do not support / recommend this approach. It was the user-schema geodatabase option.

All comments

George_Thompson

That looks like the suggested model. 1 Oracle database (instance) with 1 SDE schema. You can have multiple data owner or other schemas in the same Oracle geodatabase.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-oracle.htm

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/overview-geodatabases-oracle.htm

yockee

Hi George,

What might be the case for using this configuration ? I need a little elaboration...

thanks

George_Thompson

yockee

I see. Thanks George. That really open my mind.

I was under impression that the configuration showed in the original pict i posted was for creating 1 geodatabase that incorporating 2 databases (2 databases that make up 1 geodatabase). I was using RAID analogy in interpreting the picture, ie : multiple HDDs combines into 1 logical HDD.

Thanks for clearing up.

George_Thompson

That used to be possible, but we do not support / recommend this approach. It was the user-schema geodatabase option.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Inloggen
Registreren

Snelle Links

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