Rebuild Index

From: Gregory P Lechkun <lechkung_at_dteenergy.com>
Date: Fri, 22 Oct 1999 17:11:05 -0400
Message-ID: <3810D2E9.EC0F91B2@dteenergy.com>

Ok,

I'm using Oracle V7.3.2.3 and I decide to rebuild and index. I use the following statement:

ALTER INDEX cedi_pk REBUILD;
And what happens? It rebuilds it but it rebuilds it in my account's default tablespace (cel_d)!
I had heard of V7.3.4 doing that so, this is my question: What versions is this problem in, and is it fixed in Oracle 8.0+?

Of course the work around for now is to use the following statement:

ALTER INDEX cedi_pk REBUILD TABLESPACE cel_i;

--
Regards,
Greg Lechkun
gpl :-)

DTE

Energy====================================================================

DTE     ////// ////////////       Gregory Lechkun - EM&D/PDO-PT
DTE    //   //  //   //           Power Application Software Engineer
DTE   //   //  //   ////          lechkung_at_detroitedison.com

DTE // // // //
DTE ////// // ////// Received on Fri Oct 22 1999 - 16:11:05 CDT