Oracle-L: RE: Move index to another tablespace

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Mon, 01 Apr 2002 21:13:18 -0800
Message-ID: <F001.00438728.20020401211318@fatcity.com>

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). Received on Mon Apr 01 2002 - 23:13:18 CST