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

Encontre mais publicações marcadas com

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.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Entrar
Registrar

Links Rápidos

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