Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: separate data/inidex
"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)
No prob just rebuild your indexes using a predefined tablespace good idea to rebuild from time to time. Received on Sun Apr 21 2002 - 07:11:23 CDT