ya it is even possible in 8.1.5
NG On Tue, 02 Apr 2002 CHAN Chor Ling Catherine (CSC) wrote : >Hi Ayyappan, > >Correct me if I am wrong. I think in 8.1.6, you can use the alter >index >command to move an index to a different tablespace >eg. ALTER INDEX summit.orders_idx REBUILD TABLESPACE >new_tablespace_name; > >Regds, >New Bee > -----Original Message----- > From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 12:03 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Move index to another tablespace > > Hi > > U have to rebuild the index only. u can't able to move from >one tablespace > to another like move table. > > Regards > > Ayyappan.S > > >**************************************************************************** > This communication contains information, which is >confidential and may also > be privileged. It is for the exclusive use of the intended >recipient(s). If > you are not the intended recipient(s), please note that any >distribution, > printing, copying or use of this communication or the >information in it is > strictly prohibited. If you have received this communication >in error, > please notify the sender immediately and then destroy any >copies of it. > Visit us @ > >www.ssiworldwide.com******************************************************** > ******************** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) >538-5051 > San Diego, California -- Public Internet access / >Mailing Lists > >-------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail >message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') >and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). >You may > also send the HELP command for other information (like >subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: CHAN Chor Ling Catherine (CSC) > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) >538-5051 >San Diego, California -- Public Internet access / Mailing >Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail >message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and >in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You >may >also send the HELP command for other information (like >subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).