Re: Change index from tablespaces

From: Ellen Russell <Ellen_Russell_at_dg.com>
Date: 1997/10/27
Message-ID: <633dnu$ane@wellspring.us.dg.com>#1/1

You don't say what rev of Oracle you are running. If you are running Oracle 7.3, then you can use the command
alter index <indexname> rebuild tablespace <tablespacename>

--
Ellen_Russell_at_dg.com


Juan Leon Lahoz Garcia wrote in message <6229c6$44v_at_tid.tid.es>...


>I wanna to change the default tablespace indexes of my

>database, and move all indexes to te news tablespace.

>

>How can I do that?

>

>Thanks for your time

>

Received on Mon Oct 27 1997 - 00:00:00 CST