Some clarification on terms/routine regarding user schema SDE in oracle.

Question

Hi all,

I am a bit confused with user schema SDE oracle databases. Mainly it 2 aspects: creation and connection to them.

Can you provide a tutorial on how to create a user schema SDE DB in oracle?

And also how to connect to a specific user schema once created.

Thanks.

MartinF · Answer

is there already any experience existing with migration paths to move away from user schema geodatabase f. e. to Oracle pluggable database? What to take into account? How to treat archiving, versioning, etc.?

LeoMontero · Answer

Be aware that user schema Geodatabase creation will be deprecated.

See the full document in the link below

http://downloads.esri.com/Support/downloads/other_/DEPRECATED%20FEATURES%20PLAN%20FOR%20ARCGIS%2010.7%20and%20ArcGIS%20Runtime%20SDK%20100.x%20Year%20Year%202018%20Final%20v1%2001082019.pdf

Asrujit_SenGupta · Answer

Which version of ArcGIS Desktop are you working with?

Create a geodatabase in Oracle—Geodatabases in Oracle | ArcGIS Desktop

Note:

Beginning with ArcGIS 10.7 and ArcGIS Pro 2.3, you cannot create user-schema geodatabases in Oracle.

If you are on an older version check this: Create a geodatabase in Oracle—Help | ArcGIS Desktop  (the link shared is for 10.6)

Once the master sde geodatabase exists, you can use any of the aforementioned tools or scripts to create a user-schema geodatabase.

* Create Enterprise Geodatabase: When the database administrator runs this tool, be sure the schema owner's name is specified for the geodatabase administrator.
* Enable Enterprise Geodatabase: If you do not have access to the sys user's password, the database administrator can grant you the privileges required to create a geodatabase. Then you can connect to the geodatabase with your login and run the Enable Enterprise Geodatabase tool or script to create a geodatabase in your schema.

For connecting to an User Schema Geodatabase: Connect to a specific geodatabase version—Geodatabases in Oracle | ArcGIS Desktop

By default, the Database Connection dialog box in the Catalog window connects to the DEFAULT version of the master sde geodatabase. If you have user-schema geodatabases or use geodatabase versioning, you might want to save a connection to a different version.

To save a connection to a user-schema geodatabase or a version other than DEFAULT, follow these steps:

* Right-click your existing database connection in the Catalog window in ArcMap or ArcCatalog and click Geodatabase Connection Properties.
* Choose what type of geodatabase version you want to connect to:* Choose Transactional version to connect to a user-schema geodatabase or a transactional version other than DEFAULT.
* Choose Historical version to connect to an historical marker or specific date and time.