38.14. pga_partition_info #

This metadata table contains information about partitioned analytical tables. For more information about partitioning, refer to Chapter 30.

Column Name

Column Type

Constraint

Description

partition_id

BIGINT

Primary key

The partition ID assigned by increasing the next_catalog_id value of the pga_snapshot metadata table.

begin_snapshot

BIGINT

Foreign key, NOT NULL

The snapshot associated with creating the partitioned analytical table, from the pga_snapshot metadata table.

end_snapshot

BIGINT

Foreign key

The snapshot associated with deleting the partitioned analytical table, from the pga_snapshot metadata table.

If the value is NULL, the table is not deleted.

table_id

BIGINT

Foreign key, NOT NULL

The ID of the partitioned analytical table from the pga_table metadata table.