Introduction to storing the Reviewer workspace in a geodatabase in Oracle

ArcGIS Data Reviewer for Desktop, a data quality-control management application, requires that you have a workspace defined when using a Reviewer session to store the results found during your data review process. It creates a new feature dataset and tables in the geodatabase that you have identified as your Reviewer workspace. The feature dataset includes point, line, and polygon feature classes, which contain error geometries for the features that have been written to the Reviewer table. When stored in an enterprise geodatabase, the Reviewer workspace supports versioning.

This guidebook is intended for database administrators and provides recommendations for establishing the workspace in a geodatabase in Oracle. The enterprise geodatabase uses ArcSDE technology as the gateway between geographic information system (GIS) clients and Oracle.

Before starting this guidebook, you need to install the ArcSDE service and Oracle software.

ArcSDE service software installation

Connections to enterprise geodatabases use direct connections by default, but the ArcSDE application service is required if you want to connect to your geodatabase using the ArcSDE service connections. Direct connections are recommended.

If you will only be using direct connections and don't want the administration command line tools, ArcSDE installation isn't required.

If you want to install the ArcSDE application service or the administration command line tools, you need to download the ArcSDE installation files for your database management system and operating system from the Esri Customer Care portal. It may be useful to install the ArcSDE administration command line tools to perform certain advanced configuration operations.

For more information about ArcSDE services, see What is an ArcSDE service.

Oracle software installation

The Oracle software media kit contains instructions to install Oracle on different platforms. Refer to software media kits for an easy and fast installation. Alternatively, review documentation provided Oracle 11g standard edition software on Windows.