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

03-22-2019 05:03 AM
New Contributor III

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.


Tags (3)
0 Kudos
3 Replies
MVP Regular Contributor

Which version of ArcGIS Desktop are you working with? 

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


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.

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:

  1. Right-click your existing database connection in the Catalog window in ArcMap or ArcCatalog and click Geodatabase Connection Properties.
  2. 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.
0 Kudos
Esri Contributor

Be aware that user schema Geodatabase creation will be deprecated. 

See the full document in the link below

0 Kudos
Esri Contributor

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.? 

0 Kudos