Delete Process
The Delete Process uses a source (an Archive File) to select the archived data to be deleted and deletes the data from a destination (one or more tables in a database).
You can use the Delete Process:
- As part of the Archive Process, by instructing Archive to delete archived data from the database immediately after archiving. Use this method to archive and delete data using a single Archive Process.
- Independent of the Archive Process, by instructing Archive to defer the deletion of archived data, which lets you verify the data in the Archive File after the Archive Process completes.
To delete data independent of the Archive Process, you must create a Delete Request that includes the source file that identifies the data to be deleted, a control file to track processing, and the parameters for the Delete Process. You can process the Delete Request immediately, or schedule the process to run automatically, at predetermined intervals. You can also run the Delete Process from the command line, using overrides for specifications in the request.
Delete Request
In the Delete Request, you specify parameters necessary to perform the Delete Process, including the Source File, Control File, and process options.
Delete Request Editor
You use the Delete Request Editor to create and edit Delete Requests.
Source File
The Source File identifies the rows to be deleted from a source database. A Source File can be either an Extract or Archive File.
Control File
The Control File records the success or failure of Delete processing for each row.
Process Options
Process options establish safeguards for the Delete Process. You can specify the number of rows to process before committing changes to the database, limit the total number of rows to be discarded, lock tables during the process, and review the tables from which archived rows are to be deleted.
Delete Process Report
A Delete Process Report is generated as part of the Delete Process. The report contains general information and statistics about the process.