Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter index rebuild on Oracle
Steve Haynes wrote:
>
> In article <35DFD9DE.F291D66A_at_sybrandb.demon.nl>, Sybrand Bakker
> <postbus_at_sybrandb.demon.nl> writes
> >If the index is not in the default tablespace and you don't specify a
> >tablespace in the rebuild statement it will end up in the default
> >tablespace.
> Not true. rebuild means rebuild as is, where is.
> I only wish this were true of constraint enable/disable
> but I have an enhancement request in for that,
> Steve
> --
> "The floggings will continue until morale improves."
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.
Received on Thu Aug 27 1998 - 02:15:19 CDT