V11 SP8

Delaying Pruning on the Oracle Production Database

Note: This setting is not applicable when you use the parquet format to archive the data.

You can create the delete script and not have it run after the archive. You can schedule the script by using crontab or other tools. This conserves resources during high-volume times. The pruning scripts is in in the following directory on the archive database client.

<job results location>CV_JobResults/2/0/<jobid>/srcDeleteScript.sql


  • On the client computer, add the SkipPruneRowsOnSource additional setting as shown in the following table.

    For instructions on adding additional settings from the CommCell Console, see Add or Modify an Additional Setting.

    Property Value
    Name SkipPruneRowsOnSource
    Category OracleAgent
    Type String
    Value Y