Oracle's insights on viewing partition table information

After a long time of in-depth research on the SQL language for Oracle to view partition table information, I will share with you here. After reading this article, you will certainly have a lot of GAINS. I hope this article will teach you more.

Display partition table information in Oracle

Display information of all database partition tables: DBA_PART_TABLES

Display All the partition tables accessible to the current user: ALL_PART_TABLES

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

Show Oracle view partition table information show detailed partition information of all database partition tables: DBA_TAB_PARTITIONS

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

Displays detailed partition information for all partition tables of the current user: USER_TAB_PARTITIONS

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

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

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

Display partition column information of all database partition tables: 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 the subpartition column information of all database partition tables: DBA_SUBPART_KEY_COLUMNS

Display the information of the subpartition columns of all partition tables accessible to the current user: ALL_SUBPART_KEY_COLUMNS

Displays the information of subpartition columns in all partition tables of the current user: USER_SUBPART_KEY_COLUMNS

Bytes ---------------------------------------------------------------------------------------------------

How to query all partition tables in the Oracle database

Select * from user_tables a where a. partitioned = 'yes' Delete the data of a table is truncate table table_name;
To delete a partition table, the data in a partition is alter table table_name truncate partition p5;

If I want to clear the data of each partition in the Partition table, can I use truncate table table_name?
It must be executed from scratch.

 
 

  
  
alter table table_name truncate partition p1;   
  
  
alter table table_name truncate partition p2;   
  
  
alter table table_name truncate partition p3;   
  
  
alter table table_name truncate partition p4;   
  
  
alter table table_name truncate partition p5;   
  
  
alter table table_name truncate partition p6;   
 
 

A: truncate table table_name

1. Code required to modify the Oracle Stored Procedure
2. Summary of Oracle stored procedures
3. Code for implementing the Oracle Stored Procedure
4. In-depth high-performance dynamic Oracle SQL Development
5. Analysis of Oracle SQL optimization rules