ORACLE Partitioned Table related views

1. Displays all partition table information that the current user can access:

All_part_tables

2. Displays information about all the partition tables for the current user:

User_part_tables

3. Display table partition information displays detailed partition information for all partitioned tables in the database:

Dba_tab_partitions

4. Displays detailed partitioning information for all partitioned tables that the current user can access:

All_tab_partitions (This is my lucky O (∩_∩) o~)

5. Displays detailed partitioning information for all partition tables for the current user:

User_tab_partitions

6. Display sub-partition information displays sub-partition information for all combined partitioned tables in the database:

Dba_tab_subpartitions

7. Displays sub-partition information for all the combined partition tables that the current user can access:

All_tab_subpartitions

8. Displays sub-partition information for all the combined partition tables of the current user:

User_tab_subpartitions

9. The Display partition column displays the partition column information for all partitioned tables in the database:

Dba_part_key_columns

10. Displays the partition column information for all partitioned tables that the current user can access:

All_part_key_columns

11. Displays the partition column information for all partition tables for the current user:

User_part_key_columns

12. Show sub-partition columns displays sub-partition column information for all partitioned tables in the database:

Dba_subpart_key_columns

13. Displays sub-partition column information for all partitioned tables that the current user can access:

All_subpart_key_columns

14. Displays sub-partition column information for all partitioned tables for the current user:

User_subpart_key_columns

ORACLE Partitioned Table related views