Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Customize Your Partitioning Scheme › Customizable Pre-and Post-Operation Procedures

Customizable Pre-and Post-Operation Procedures

Customizable pre- and post-operation procedures are invoked by operations in the purge process. You can define customized procedures in the package body of wgn_partition_cust. If no customized procedures are defined, CA DataMinder invokes default procedures. These default procedures do nothing. The procedure prototypes are listed below.

Creating a temporary table

These procedures are invoked immediately before or after creating a temporary table to hold events that need to be retained.

Pre-operation

PROCEDURE wgn_pre_create_temp_table
(table_name IN VARCHAR2,
date_range IN VARCHAR2);

Post-operation

PROCEDURE wgn_post_create_temp_table
(table_name IN VARCHAR2,
date_range IN VARCHAR2);

Populating the blob deletion queue

These procedures are invoked immediately before or after populating the blob deletion queue.

Pre-operation

PROCEDURE wgn_pre_pop_blob_deletion 
(date_range IN VARCHAR2);

Post-operation

PROCEDURE wgn_post_pop_blob_deletion 
(date_range IN VARCHAR2);

Truncating a partition

These procedures are invoked immediately before or after truncating a partition.

Pre-operation

PROCEDURE wgn_pre_truncate_partition 
(table_name IN VARCHAR2, 
date_range IN VARCHAR2);

Post-operation

PROCEDURE wgn_post_truncate_partition 
(table_name IN VARCHAR2, 
date_range IN VARCHAR2);

Exchanging a temporary table with a purged partition

These procedures are invoked immediately before or after exchanging a temporary table (holding retained events) with the partition being purged. In effect, these procedures can be invoked immediately before or after merging retained events back into the original partition.

Pre-operation

PROCEDURE wgn_pre_exchange_partition
(table_name IN VARCHAR2,
date_range IN VARCHAR2);

Post-operation

PROCEDURE wgn_post_exchange_partition
(table_name IN VARCHAR2,
date_range IN VARCHAR2);

Merging a temporary table into a historic partition

These procedures are invoked immediately before or after merging a temporary table (holding retained events) into a historic partition—a special partition for holding records that must be retained permanently. Any permanent records from the purged partition are merged into this historic partition.

Pre-operation

PROCEDURE wgn_pre_merge_partitions
(table_name IN VARCHAR2,
historic_partition IN VARCHAR2,
date_range IN VARCHAR2);

Post-operation

PROCEDURE wgn_post_merge_partitions
(table_name IN VARCHAR2,
historic_partition IN VARCHAR2,
date_range IN VARCHAR2);