Re: separate data/inidex

From: Troy Meyerink <meyerink_at_usgs.gov>
Date: Thu, 18 Apr 2002 20:45:58 GMT
Message-ID: <Gus70n.CA3@igsrsparc2.er.usgs.gov>

You need to create an index tablespace and then move the existing indexes by issuing an
'alter index rebuild' statement.

Troy Meyerink
Oracle DBA
Raytheon

"Titi" <thierry.constant2_at_wanadoo.fr> wrote in message news:3cbf2607$0$15182$626a54ce_at_news.free.fr...
> Hi,
>
> For a user, I have data and index in one tablespace.
> I want to separate data and index ( good idea ??)
>
> How can do that ???
>
> Thanks in advance ...
> ( oracle 8.1.7)
>
>
Received on Thu Apr 18 2002 - 15:45:58 CDT