How to reduce space-INDEXes...LOBSEGMENT,LOBINDEX..
Hi,
I need suggestion.
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
I have few huge tables,INDEXes...LOBSEGMENT,LOBINDEX..in a user..i need to reduce the size as thses tables are huge and have records of last 1 year...i want recorsd of last 60 days (i can do it using the colunm which has the date)....
Can anyone tell me what to do with the one with LOB_SEGMENT/INDEX....as they r taking lot of space....how to release thr space...
Any good suggestion on how to go forward about reducing the space..
Iam planning to take 60 days records to put in a temp table...then truncate the base table...then insert it back ,create indexes...and analyze the tables...
ObjectName ObjectType SizeBytes
EAI_WAS TABLE 2558525440
EAI_DATAMESSAGE TABLE 159383552
EAI_ERROR TABLE 276824064
EAI_STOREDPROCLOG TABLE 379584512
EAI_TRACE TABLE 1582301184
SYS_IL0000101308C00010$$ LOBINDEX 65536
SYS_IL0000101312C00008$$ LOBINDEX 10485760
SYS_IL0000101316C00010$$ LOBINDEX 65536
IDX_EAI_DATAMSG_ENTITYID INDEX 22020096
IDX_EAI_DATAMSG_SEQUENCEGROUP INDEX 19922944
IDX_EAI_DATAMSG_INTEGRATIONID INDEX 32505856
IDX_EAI_AUDIT_INTEGRATIONID INDEX 606076928
IDX_EAI_TRACE_INTEGRATIONID INDEX 201326592
PK_USER INDEX 65536
SYS_LOB0000103037C00010$$ LOBSEGMENT 192937984
SYS_LOB0000103037C00013$$ LOBSEGMENT 1128267776
SYS_LOB0000103037C00024$$ LOBSEGMENT 2750414848
SYS_LOB0000101308C00010$$ LOBSEGMENT 327155712
SYS_LOB0000101312C00008$$ LOBSEGMENT 9252634624
SYS_LOB0000101316C00010$$ LOBSEGMENT 152043520
SYS_LOB0000101316C00013$$ LOBSEGMENT 894435328
SYS_LOB0000101316C00024$$ LOBSEGMENT 3066036224
SYS_LOB0000101325C00009$$ LOBSEGMENT 494927872
SYS_LOB0000101325C00019$$ LOBSEGMENT 159383552
SYS_LOB0000102357C00004$$ LOBSEGMENT 720896