Hello,
i am using ORACLE 11g R1 and RHEL 5.
I have huge size of DB. For better performance i kept the tables and its indexes on different tablespaces. These tablespaces are on different disk drives. Till now i was getting good performance. Recently i faced the issue that my INDEX TABLESPACE is full.
NAME SIZE[M] Free[M] Used[M] Usage[%]
INDEXTBSP 1228.8 7.6 1221.2 99.4
Now i want to free the space on this tablespace. What should i do ??? I searched it on net...it has a solution in Oracle 11g R2 but i am using 11g R1.
I tried to rebuild it, but no use.
Can you tell me some solution by which i can regularly free space from index tablespace. I mean to say i have to free the space used by the index on its tablespace.
Thanks in advance ...