Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: alter index rebuild on Oracle

Re: alter index rebuild on Oracle

From: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: Mon, 24 Aug 1998 19:42:25 +0100
Message-ID: <pbiD6CARQb41EwZz@rwx777.demon.co.uk>


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." Received on Mon Aug 24 1998 - 13:42:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US