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 ??!!
Welcome!