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 Oracle Database 11g, this is the method to use.
- If you're using the multitenant architecture available starting with Oracle Database 12c, you can also 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.
Legacy:
Creation of user-schema geodatabases is no longer supported.