Skip Headers
Oracle® Identity Manager Upgrade Guide
Release 9.1.0 ( Upgrade)

Part Number E13340-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

C Reconciliation Archival

The Reconciliation Archival utility archives data from active reconciliation tables to archival reconciliation tables and to delete data from the active and archival reconciliation tables.

This utility is added to increase performance. Run this utility only if you want to archive the reconciliation data. Data is transferred from the active reconciliation tables to the new archival tables. As a result, extracting active reconciliation data takes less time, and the performance improves.

This appendix discusses the following topics:

C.1 Location and Components

All Oracle Identity Manager database reconciliation archival files are located in the PATCH/db/oracle/Utilities/ReconArchival directory when you are using Oracle Database. Table C-1 provides details of the files that are part of the Oracle Identity Manager Reconciliation Archival utility:

Table C-1 Reconciliation Archival Files

File Description


Creates the OIM_RECON_DDL table. This table is used by the Reconciliation Archival utility, which calls the OIM_SP_ReconArchival stored procedure to store the DDL statements that are generated when the tool archives or deletes the reconciliation data.


Creates arch_rc* tables with the same structure as the active reconciliation tables. In addition, a primary key is added by the script to the tables.


Archives reconciliation data into the reconciliation archival tables and deletes the archived data from active reconciliation tables. It also allows you to clean up the data in archival and active reconciliation tables.

C.2 Oracle Identity Manager Reconciliation Archival Functionality

To use the Reconciliation Archival utility, run the following script:

For Microsoft Windows, run OIM_ReconArch.bat.

For UNIX, run

After you run the script, a log file is generated with the following name:

For Microsoft Windows:


C.2.1 Authentication

When you run the Reconciliation Archival utility, you are prompted to enter the following information:

  • Name of the Oracle home directory

  • Database name

  • Database user name

  • Database password

The utility permits only three connection attempts.

C.2.2 Functionality

The following options are present in the Reconciliation Archival utility main menu:

  • Archive data from active reconciliation tables: Provides options to archive selective data or all the data

  • Delete all data from archival reconciliation tables: Provides options to delete all the data from the reconciliation archival tables

  • Delete all data from active reconciliation tables: Provides the options to delete all the data from the active reconciliation tables

  • Exit: Exits the Archival Utility