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

user-schema geodatabase deprecation

coolgis

We have Arcgis Enterprise 10.8.1 with Oracle geodatabase.

It has several user-schema geodatabases with existing database users.

I want to move the data from the user-schema geodatabases into the sde geodatabase.

From arcgis pro , I connected to userschema geodatabase as a schema user. and connected to sde schema as a sde user.

Can I copy data from user-schema geodatabases and paste into the sde geodatabase.

Is this process correct?

If I have ABC user with ABC schema. I just copy the data into SDE schema. and then assign the privileges to ABC user?

I find the esri documentation confusing. why esri doesn’t make it clear ?

why there is a need to create a new database user if one already exists ?

If there is no user schema , how do we distinguish between different users or type of data?

How does users access their data only and not being able to edit others data?

Is there any issues with all the users data owned by SDE?

Thanks

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

coolgis

Hi @George_Thompson @MarceloMarques

I checked both test and prod Oracle database Instances table and they have only one SDE row.

How else do I know that there is no user-schema geodatabases?

I can see different schemas in arcgis pro catalog when i connected as different schema owners sde connection file. and the tables in each schema are prefixed by schema name.

@MarceloMarques

If these user-schema geodatabases exist. I was planning to use option1.

Create new Oracle DB first as you recommended. Then create SDE geodatabase.

Then move the data into SDE and then assign the privileges to the DB users.

May I know why are you recommending option 3?

Does this increase the Oracle cost?

Thanks

MarceloMarques

Move user-schema geodatabases to stand-alone geodatabases in Oracle—ArcGIS Pro | Documentation

the documentation mentions 3 options:

1. Move the data from the user-schema geodatabases into the sde geodatabase
2. Move all user-schema and sde geodatabase data to a new geodatabase
3. Move each user-schema geodatabase into its own stand-alone geodatabase

I recommend using the 3rd option and move to an Oracle Container Database and Oracle Pluggable Databases, each Pluggable Database is a Geodatabase.

I hope this clarifies.

George Thompson

Then you may not have user schema geodatabases configured right now. I believe that if you have them configured, the other geodatabases would be listed there.

I have to admit, it has been a while since I used a user-schema Oracle geodatabase.

coolgis

Thanks @George_Thompson @MarceloMarques

@George_Thompson Instances table in sde master schema database shows only one row with SDE.

Should this have all other user schema geodatabases listed here?

@MarceloMarques Esri documentation doesn’t mention that new database is required. Which should be clearly mentioned. I will have a look at your scripts later. Its much more advanced level than me. I want to use simple frontend tools to do the job.

MarceloMarques

The Esri User-Schema Geodatabase is now deprecated in the Oracle database.

You need to use Oracle Pluggable Databases going forward for consolidation.

Consolidation = 1 Oracle Database Instance hosts many Esri Geodatabases.

There is no automatic migration path from User-Schema Geodatabases.

Move user-schema geodatabases to stand-alone geodatabases in Oracle—ArcGIS Pro | Documentation

You cannot just copy the data from the User-Schema Geodatabase into the SDE Master Geodatabase because your Geodatabase Repository will still be an User-Schema Geodatabase.

You need to create a new Oracle CDB Container Database Instance, then create Pluggable Databases PDBs in the CDB.

Each PDB will be an Esri Geodatabase.

Then you need to create the sde user and create the Geodatabase Repository in the PDB, next create data owner users, and then use ArcGIS Pro to copy the data from the old User-Schema Geodatabase into the new Geodatabase.

You can find my database template scripts and more information in the links below.

community.esri.com - Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

Database Connections Best Practices

Tip : read the Production Mapping Guide Book for Oracle, those are generic and the best practices can be applied to any industry, and you can download my database template scripts for Oracle, the scripts show in detail how to setup the Oracle CDB, PDB, sde repository, data owner users, and editor and viewer users.

I hope this clarifies your question.

George Thompson

@MarceloMarques anything to add here?

George Thompson

You can create a user schema within the main Oracle SDE geodatabase (i.e., DATA / GIS / Whatever). Then copy data in as that schema that you just created.

There are multiple options provided that you can do for the migration of the user-schema geodatabases: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/migrate-user-schema-geodatabases.htm as you noted.

What do you have in your instances tables in the SDE schema?

This will show how many user schema EGDB's are present.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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