Enterprise geodatabases are collections of objects—such as tables, views, and stored procedures—in a relational database management system. Oracle is one such database management system in which you can store a geodatabase.
Because the enterprise geodatabase is stored in a database, you (or someone else in your organization) must be an Oracle database administrator. The database administrator and the geodatabase administrator work together to create and maintain enterprise geodatabases.
The database administrator performs database tasks, such as creating and configuring the database, creating users, granting the users database permissions, creating and testing backups, and upgrading the database.
If you are the geodatabase administrator, you need to know how to do the following:
- Create a geodatabase in the Oracle database that the database administrator creates. Alternatively, the database administrator can create the geodatabase.
- Manage connections to the geodatabase. The geodatabase administrator can monitor, block, and drop connections.
- Perform geodatabase maintenance tasks such as compressing the geodatabase if you use traditional versioning, updating statistics on geodatabase system tables, and upgrading the geodatabase to take advantage of new functionality and fixes.
You can create a geodatabase in an existing Oracle database and continue to store database tables and views (in other words, those not registered with the geodatabase) alongside geodatabase data. You can view and publish both types of data in ArcGIS Pro, but be aware of the following:
- Geodatabase data can be edited in ArcGIS Pro when you access it through a database connection, but database data cannot. To edit database data, you must publish an editable web feature layer that references the data in the database.
- If the database contains geodatabase system tables, it is considered a geodatabase in ArcGIS. Even if you connect to tables that are not registered with the geodatabase, ArcGIS client and geodatabase release compatibility rules still apply.
Tip:
There are differences in how data is stored and accessed in each supported database management system, which affect how you interact with the database and the geodatabase objects in it. For this reason, enterprise geodatabase management help has been grouped into sections based on the database management system. This section of the help provides information about administering an enterprise geodatabase in a Oracle. If you access a topic using the search, be sure you are reading the topic that applies to the database management system you are using.