Home  >  Article  >  Database  >  How to query partition table in oracle

How to query partition table in oracle

WBOY
WBOYOriginal
2022-02-17 17:27:5530102browse

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;".

How to query partition table in oracle

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn