Using functions

There are several functions you can use to display partition information. See the Reference Manual: Building Blocks for complete syntax and usage information.

Examples

This example returns the number of pages used by the object with an ID of 31000114 in the specified database. The number of pages includes those for indexes.

data_pages(5, 31000114)

This example returns the partition ID corresponding to the testtable_ptn1 partition.

select partition_id(“testtable”, testtable_ptn1”)

This example returns the partition name for the partition ID 1111111111 belonging to the base table with an index ID of 0.

select partition_name(0, 1111111111)