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

D Task Archival

You run this utility to archive the task data. When you run this utility, data is transferred from the active task tables to the new archival tables. As a result, extracting active task data takes less time and the performance improves.

This appendix discusses the following topics:

D.1 Location and Components

All Oracle Identity Manager Task Archival files are located in the PATCH/db/oracle/Utilities/TaskArchival directory when you are using Oracle Database. Table D-1 provides details of the files that are part of the Oracle Identity Manager Task Archival utility:

Table D-1 Task Archival Files

File Description


Creates the OIM_TASK_ARCH_DDL table. This table is used by the Task Archival utility, which calls the OIM_SP_TASKS_ARCHIVAL stored procedure to store the DDL statements that are generated when the tool archives or deletes the tasks data.


Creates the arch_* tables that have the same structure as the active tasks tables. In addition, this script afds a primary key to tables.


Archives task data into the task archival tables and deletes the archived data from the active task tables.

D.2 Oracle Identity Manager Task Archival Functionality

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

For Microsoft Windows: OIM_TasksArch.bat


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

For Microsoft Windows:


D.2.1 Authentication

When you run the script, you are prompted to enter the following information:

  • Name of the Oracle home directory

  • Database name

  • User name

  • Database password

The utility permits only three connection attempts.

D.2.2 Functionality

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

  • Archive all the provisioning tasks on resource instances, which have been revoked for disabled/deleted users

  • Archive all the provisioning tasks on resource instances, which have been revoked

  • Archive all the approval tasks in which the request status is Request Complete/Request Cancelled/Object Approval Complete

  • Exit