Re: alter index rebuild on Oracle

It is true in Oracle version 7.3.X but Oracle change it in Oracle 8.X.

So in Oracle 7, the rebuild index will rebuild the index in the default tablespace of the user
in Oracle 8, the rebuild index will rebuild it in is original tablespace.

Vishal wrote in message <35E65D67.68C8E1F8_at_hotmail.com>...
>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 - 21:52:03 CDT