Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How can I cliam the free space while altering the index?
I am altering the INDEX from tablespace ABC to XYZ as following way..
ALTER INDEX my_index REBUILD TABLESPACE xyz STORAGE ( INITIAL 593920 NEXT 286720 PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 121 ) This alter theindex but i don't see any changes in free space happen to ACB tablespace.? Is there something i am missing.??... Thanks in advance for any help..
Ashesh
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Jun 25 1998 - 11:46:17 CDT
![]() |
![]() |