select table_owner, table_name, partition_name, tablespace_name from dba_tab_partitions;

select TABLE_NAME,PARTITION_COUNT from user_part_tables;