Table or Index or Partition Size in Oracle PLSQL database

You can find everything from this table

select * from user_segments;


Distinct Segment Types:
LOBINDEX
TABLE SUBPARTITION
TABLE PARTITION
LOBSEGMENT
TABLE
INDEX