Introduction to storing the Reviewer workspace in a geodatabase in Oracle
ArcGIS 10.1 Data Reviewer for Desktop extension, 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 guide book is intended for database administrators as 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 guide book, you need to install the ArcSDE service and/or 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, then ArcSDE installation isn't required.
If you want to install the ArcSDE application service and/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.
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 in the link below.
Learn more about installing Oracle 11g standard edition software on Windows