Multiple geodatabases in Oracle

To store multiple geodatabases when using an Oracle database management system, do one of the following:

  • Install separate instances of Oracle and, in each instance, create a geodatabase.
  • If you use the Oracle multitenant architecture, you can use pluggable databases and create a geodatabase in each pluggable database.

In both cases, each geodatabase is maintained and upgraded independently. Each database can also be deleted independently. In each database, the geodatabase system tables are stored in the sde user's schema and user data is stored in the schemas of individual users.

Two geodatabases, each in their own Oracle database


Creation and upgrade of geodatabases created in the schema of a user other than sde (referred to as user-schema geodatabases) is no longer supported.