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.
--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!