user-schema geodatabase deprecation

[coolgis]

Hi

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

[coolgis]

Hi @MarceloMarques 

Database query and ArcGIS pro screenshots match as yours.

You both are amazing and of great help.

Really appreciated.

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.