Database Administration (MOSC)

MOSC Banner

index size is larger than table size

edited Jul 10, 2014 5:00AM in Database Administration (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center