PARTITION_PURGE
Definition
The PARTITION_PURGE table contains defines the number of days/partitions of data stored
in tables and the number of
days/partitions created in advance
Technical Data
| Schema Version |
4.5.2 |
| Filegroup |
BART_DATA |
| Partitioned |
No |
Summary
The PARTITION_PURGE table is defined by the
following columns.
See the column details for more information.
Column Details
PARTITION_DAYS
| Definition |
The number of days that must be kept in the database |
| Type |
DECIMAL(3), NOT NULL |
PARTITION_ADVANCE_DAYS
| Definition |
The number of partitions that must be created in advance |
| Type |
DECIMAL(3), NOT NULL |
LAST_PARTITION_DIRECTORY_ID
| Definition |
This field is used to choose the next directory when creating a new tablespace or
filegroup
|
| Type |
DECIMAL(3), NULL |