RE: Truncated table!!index still holding space??

2001-12-19 Thread Mark Leith
alter index rebuild HTH Mark -Original Message- Sent: 19 December 2001 14:01 To: Multiple recipients of list ORACLE-L Hi Friends, I have two tables sized more than 2.3Gb has each index 700Mb, I truncated both tables!! I got space back of from tables, But indexes still showing its h

Truncated table!!index still holding space??

2001-12-19 Thread Raghu Kota
Hi Friends, I have two tables sized more than 2.3Gb has each index 700Mb, I truncated both tables!! I got space back of from tables, But indexes still showing its holding space(I got from dba_segments), It looks weired!! Mine is oracle7.3 in AIX. Thanks Raghu. ___