PARTITION_STATUS
Definition
The PARTITION_STATUS table gives the partition date, the directory of the data file
and the status of each partition
Technical Data
| Schema Version |
4.5.2 |
| Filegroup |
BART_DATA |
| Partitioned |
No |
Summary
The PARTITION_STATUS table is defined by the
following columns.
See the column details for more information.
Column Details
PARTITION_DATE
| Definition |
The date when the partition was created |
| Type |
DATETIME, NOT NULL |
DIRECTORY_ID
| Definition |
The directory where the data is stored |
| Type |
DECIMAL(2), NOT NULL |
STATUS
| Definition |
The status of the partition |
| Format |
The possible values are:
For Oracle technology
- 0: tablespace created
- 1: partition for the CDR table created
- 2: all partitions created
- 3: tablespace archived
- 4: tablespace imported
- 5: empty CDR partition created
- 6: CDR partition restored
- 7: tablespace restored
For SQL Server technology
- 0: filegroup created
- 1: partition for the CDR table created
- 2: all partitions created
- 3: CDR partition archived
- 4: filegroup created
- 5: empty CDR partition created
- 6: CDR partition restored
|
| Type |
DECIMAL(2), NOT NULL |
