RE: index in data tablespace ???

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Thu, 06 Sep 2001 10:40:40 -0700
Message-ID: <F001.003859EC.20010906105351@fatcity.com>

You can use ALTER INDEX <index_name> REBUILD TABLESPACE <tablespace name>;

You can create these statements for you such as

SPOOL rebuild_index.sql
SELECT ' ALTER INDEX ' ||index_name || ' REBUILD TABLESPACE <tablespace name>;'
FROM DBA_INDEXES
WHERE tablespace_name = 'indexes_in_data_tablespace_to_move'; spool off

substitute the <tablespace_name> with destination tablespace Rick

-----Original Message-----
Sent: Thursday, September 06, 2001 2:37 PM To: Multiple recipients of list ORACLE-L

Hi all,

I got bunch of indice reside in data tablespace. What's an easy, safy way to move them into index tablespace?

Thank you.

Janet

Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Janet Linsy
INET: janetlinsy_at_yahoo.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: Cale, Rick T (Richard)
INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------