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.

Name PK FK IX Uses Used by
PARTITION_DAYS          
PARTITION_ADVANCE_DAYS          
LAST_PARTITION_DIRECTORY_ID          

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