Re: alter index rebuild on Oracle

I guess it depends on the version, because it is true in Oracle 7.3.2.3

Vishal

Steve Haynes wrote:

> In article <6s316p$lom$1_at_news-2.news.gte.net>, James Tong
> <jtong15_at_hotmail.com> writes
> >If the owner's default tablespace is different from the index tablespace
> >and not specifying a tablespace in the rebuild statement,
> >the rebuilt index(es) will end up in the default tablespace. Just be
> >careful.
> I tried this on 8.0.4.1.4, in fact I have a authored a whole
> suite of packages to maintain indexes and the above is absolutely
> not true.
> Steve
> P.S
> If it were true, it would be stupid design, rebuild a house
> doesn't mean rebuild it elsewhere.
> P.P.S
> I will test this for the 3rd time in the morning.
> --
> "The floggings will continue until morale improves."
Received on Fri Aug 28 1998 - 02:33:59 CDT