How do I know if an object is partitioned or not?

posted Aug 11, 2011, 6:00 PM by Sachchida Ojha
SELECT * FROM dba_part_tables;
SELECT * FROM dba_part_indexes;

One can list the partitions of a table with:

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

One can show the partitions of an given index with:

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