index size is larger than table size
SQL> select segment_name , bytes/1024/1024, tablespace_name from dba_segments where segment_name like 'B_READINP%';
SEGMENT_NAME BYTES/1024/1024 TABLESPACE_NAME ------------------------------ --------------- ------------------------------
B_READINP 150 SYSAUX B_
READINP_IDX1 281 SYSAUX
B_READINP_IDX2 224 SYSAUX
B_READINP_IDX3 187 SYSAUX
B_READINP_IDX4 62 SYSAUX
B_READINP_IDX5 1 SYSAUX
3 indexes are larger than table size. I rebuild 4 indexes and check the size again, they are still the same. Than I drop 4 indexes and recreate them
SQL> select segment_name , bytes/1024/1024, tablespace_name from dba_segments where segment_name like 'B_READINP%';
SEGMENT_NAME BYTES/1024/1024 TABLESPACE_NAME ------------------------------ --------------- ------------------------------
B_READINP 150 SYSAUX