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).
