Re: separate data/inidex

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 29 Apr 2002 07:46:03 -0700
Message-ID: <a8aed4.0204290646.4743b954@posting.google.com>

gitaya_at_hotmail.com (MauMau) wrote in message news:<1391a36e.0204210411.c3a275_at_posting.google.com>...
> "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.

Here goes Another Myth ... Can U tell us why u need to Rebuild teh Indexes from Time to Time...

Regards,
Ganesh R Received on Mon Apr 29 2002 - 09:46:03 CDT