Re: RE: Move index to another tablespace

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: ayyappan.subramaniyan_at_SSIWORLDWIDE.COM
>[mailto:ayyappan.subramaniyan_at_SSIWORLDWIDE.COM]
> 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: ayyappan.subramaniyan_at_ssiworldwide.com
>
> 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: ListGuru_at_fatcity.com (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: clchan_at_nie.edu.sg
>
>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: ListGuru_at_fatcity.com (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: focussed_at_rediffmail.com

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: ListGuru_at_fatcity.com (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).