Upgrade a user-schema geodatabase

Available with Standard or Advanced license.

Legacy:

Beginning with 10.8.2, you cannot upgrade user-schema geodatabases. See the Deprecated features plan for year-end 2020.

Prior to 10.7 and ArcGIS Pro 2.3, you could create multiple geodatabases in one Oracle database by creating geodatabases in the schemas of users other than sde. For this reason, these geodatabases are referred to as user-schema geodatabases. These geodatabases contain their own geodatabase system tables.

User-schema geodatabases are not entirely self-contained, though; some functionality, such as user-defined types, are only implemented in the geodatabase in the sde user's schema. That means the following:

• You cannot upgrade a user-schema geodatabase while the sde geodatabase is being upgraded. Schema owners upgrade their geodatabases after the sde user upgrades the sde geodatabase. Each schema owner must be granted privileges to upgrade.
• You must upgrade the sde geodatabase before you upgrade geodatabases in user schemas. You will receive the following message if you try to upgrade a user-schema geodatabase before upgrading the sde geodatabase:

  Cannot upgrade a user schema geodatabase
  when the master schema geodatabase is at a previous release.
  The master schema geodatabase must be upgraded first.
  ERROR: Geodatabase schema object install not completed.

• You must make a backup of the entire database; creating a backup of only a user's schema does not include the user-defined types and functions.

It is recommended that you keep all the geodatabases in the same Oracle instance at the same ArcGIS release, but you do not have to upgrade all the user-schema geodatabases in the Oracle database.

Caution:

Users cannot register data in multiple geodatabases in the same Oracle database. If a user owns data that is registered in both the sde geodatabase and a user-schema geodatabase or in multiple user-schema geodatabases, upgrading will fail. If this occurs, the user must move his or her data into one geodatabase. This can be done using import tools, export tools, or copy and paste. After the data is moved, delete it from the other geodatabase.

The following steps explain how to upgrade a user-schema geodatabase using the Upgrade Geodatabase tool opened from the Database Properties dialog box:

1. Make sure a backup has been made of the entire Oracle database.
2. Follow the instructions to prepare for an upgrade.
3. Make sure the sde geodatabase is already upgraded.
4. Start the ArcGIS Desktop application from which you want to upgrade your user-schema geodatabase.
5. Connect to the user-schema geodatabase you want to upgrade. Log in as the schema owner.
6. Right-click the geodatabase connection and click Properties.
7. Click the General tab.

   If the geodatabase can be upgraded, the Upgrade Geodatabase button (ArcMap) or Run Upgrade button (ArcGIS Pro) is active.

Note:

You cannot run the Upgrade Geodatabase tool if any other geoprocessing tools are currently running as background processes on the client machine.

Esri recommends that you perform prerequisite checks before you upgrade. The prerequisite check detects other active connections to the geodatabase, whether the connecting user has sufficient privileges to upgrade the geodatabase, and that the database can support XML columns; makes sure all datasets can be opened; ensures that the sde geodatabase has been upgraded before any user-schema geodatabases can be upgraded; and detects that the database and libraries are at the same release. If any prerequisite is not met, the tool terminates. You must correct any problems before you run the upgrade procedure again.
8. Click the Upgrade Geodatabase button (ArcMap) or Run Upgrade (ArcGIS Pro) button to run the Upgrade Geodatabase tool.
9. If the geodatabase passes the prequisites check and you left the Upgrade Geodatabase option checked, the tool proceeds with the upgrade. The prequisite check and upgrade status are displayed in the geoprocessing tool progress dialog box. If the upgrade fails, the tool writes information to the GDBUpgrade.log. Additional information is written to the sde_setup.log file, which can be found in the system TEMP directory.
10. When the tool successfully completes, click Close to close the geoprocessing tool progress dialog box.

Your geodatabase is upgraded to the latest release.