Database Reference
In-Depth Information
table. The script also has advanced filters to set a commit batch size and max-
imum run time to control execution time and prevent them from running indefin-
itely. A sample purging script provided here, demonstrates the use of a looped
purging that iterates through the tables in the Dehydration Store to delete in-
stances falling in the date ranges specified by the
max_creation_date
and
min_creation_date
timestamps:
ALTER SESSION SET CURRENT_SCHEMA=
[PREFIX]__SOAINFRA;
DECLARE
MAX_CREATION_DATE TIMESTAMP;
MIN_CREATION_DATE TIMESTAMP;
BATCH_SIZE INTEGER;
MAX_RUNTIME INTEGER;
RETENTION_PERIOD TIMESTAMP;
BEGIN
MIN_CREATION_DATE := TO_TIMESTAMP(
'2005-11-01'
,'YYYY-MM-DD');
MAX_CREATION_DATE := TO_TIMESTAMP(
'2012-11-09'
,'YYYY-MM-DD');
MAX_RUNTIME :=
120
;
BATCH_SIZE :=
20000
;
SOA.DELETE_INSTANCES(
MIN_CREATION_DATE => MIN_CREATION_DATE,
MAX_CREATION_DATE => MAX_CREATION_DATE,
BATCH_SIZE => BATCH_SIZE,
MAX_RUNTIME => MAX_RUNTIME,
PURGE_PARTITIONED_COMPONENT => TRUE);
END;
The following table explains the different filters that can be set in the looped pur-
ging script:
