select * from user_tab_subpartitions t where t.table_name = upper('tablename');
select * from user_tab_partitions t where t.table_name = upper('tablename');

 



what the hell is going on ??!!