How does one list the partitions of a partitioned object?

One can list the partitions of a table with:

Code:

SELECT * FROM dba_tab_partitions WHERE table_name = '<table_name>';

One can show the partitions of an given index with:

Code:

SELECT * FROM dba_ind_partitions WHERE index_name = '<index_name>';