About Complete Nuke Cleanup Utility

The Complete Data Cleanup Utility helps to purge huge volume data sets in non-production environments.

Using the Complete Data Cleanup Utility, you can purge data of Oracle Identity Governance entities, such as reconciliation, provisioning task, certification, audit legacy, and orchestration in the non-production environment.

Oracle recommends using the Complete Data Cleanup Utility when you have to completely remove the data of all or any of the entities, such as reconciliation, provisioning task, certification, audit legacy, and orchestration.

Some of the key features of the Complete Data Cleanup Utility are:

  • The Complete Data Cleanup Utility supports data purge based on Oracle Identity Governance entity type.

  • The Truncate Table approach is used to purge data. Also, storage space for the purged data set is automatically reclaimed.

  • You can perform the complete nuke cleanup operation by using the PL/SQL block.

  • The logging of the Complete Data Cleanup Utility is disabled in Oracle Identity Governance by default.

  • The Complete Data Cleanup Utility uses the existing PL/SQL diagnostic logging and debugging framework to track the progress of the cleanup operation.

  • The summary and detailed information for the complete nuke cleanup operation is captured in two separate diagnostic logging tables, DIAG_LOG and DIAG_LOG_DTLS.

  • If an error is encountered during the execution of complete nuke cleanup, then rectify the error and retry. If the environment is required immediately, then restore the schema from the backup.