Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How can I cliam the free space while altering the index?

How can I cliam the free space while altering the index?

From: <ashesh48_at_my-dejanews.com>
Date: Thu, 25 Jun 1998 16:46:17 GMT
Message-ID: <6mtuss$h47$1@nnrp1.dejanews.com>


  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 the
index 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US