How to query partition table in oracle

In Oracle, you can use the select statement with "DBA_PART_TABLES" to query the partition table. This statement can display the information of all partition tables in the database. The syntax is "select * from DBA_PART_TABLES;".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to query partition table in oracle

--oracle View the partition table information of the current user;

select * from  USER_PART_TABLES;

--View all partition table information of the database;

select * from dba_part_tables;

View partition table information is organized as follows:

Display the information of all partition tables in the database: DBA_PART_TABLES

Display the information of all partition tables accessible to the current user: ALL_PART_TABLES

Display information about all partition tables of the current user: USER_PART_TABLES

Display table partition information Display detailed partition information of all partition tables in the database: DBA_TAB_PARTITIONS

Display detailed partition information of all partition tables accessible to the current user : ALL_TAB_PARTITIONS

Display detailed partition information of all partition tables of the current user: USER_TAB_PARTITIONS

Display sub-partition information Display sub-partition information of all combined partition tables of the database: DBA_TAB_SUBPARTITIONS

Display the current Subpartition information of all combined partition tables accessible to the user: ALL_TAB_SUBPARTITIONS

Displays subpartition information of all combined partition tables of the current user: USER_TAB_SUBPARTITIONS

Display partition columns Displays the partition columns of all partition tables in the database Information: DBA_PART_KEY_COLUMNS

Display the partition column information of all partition tables accessible to the current user: ALL_PART_KEY_COLUMNS

Display the partition column information of all partition tables of the current user: USER_PART_KEY_COLUMNS

Display sub The partition column displays the sub-partition column information of all partition tables in the database: DBA_SUBPART_KEY_COLUMNS

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to query partition table in oracle. For more information, please follow other related articles on the PHP Chinese website!