Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter index rebuild on Oracle
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 Thu Aug 27 1998 - 17:02:10 CDT