Delaying Pruning on the Oracle Production Database

Updated

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
    

Procedure

  • 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

    dY

Was this page helpful?