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 5.0.5
Filegroup BART_DATA
Partitioned No

Summary


The PARTITION_STATUS table is defined by the following columns in your back-end database. See the column details for more information.

Name PK FK IX Uses Used by Definition
PARTITION_DATE        

    The date when the partition was created
    DIRECTORY_ID        

      The directory where the data is stored
      STATUS        

        The status of the partition

        More...

        Column Details

        The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

        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