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>'; |