Re: Rebuild Index

From: <miaemp_at_my-deja.com>
Date: Tue, 26 Oct 1999 17:03:39 GMT
Message-ID: <7v4mt8$a0t$1@nnrp1.deja.com>

We just finished last week moving all of our indexes for one production db(ver7.3.3.6), including primary keys, off of RAID5. We used alter index as you did below and did not have problems with going into my schema. The only difference I can see is that I did an 'ALTER INDEX schema.index_name' and specified tablespace, pctfree and storage. If you don't do that, it will take defaults. This may be happening due to not specifying the schema on the rebuild.

Hope this helps

Tx
Eric Peterson
Programmer/Analyst DBA
Maurices Inc.
eric_peterson_at_maurices.inrg.com*******NO_SPAMMERS******

In article <3810D2E9.EC0F91B2_at_dteenergy.com>, Gregory P Lechkun <lechkung_at_dteenergy.com> wrote:
>
> --------------7E092445895DDEE5432B5473
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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 ////// // //////
>
> --------------7E092445895DDEE5432B5473
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> Ok,
> I'm using Oracle V7.3.2.3 and I decide to rebuild and index. 
I
> use the following statement:
>     <tt>ALTER INDEX cedi_pk REBUILD;</tt>
> 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:
>     <tt>ALTER INDEX cedi_pk REBUILD TABLESPACE
cel_i;</tt>
>  
> --
> 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 //////   //   //////
>  </html>
>
> --------------7E092445895DDEE5432B5473--
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 26 1999 - 12:03:39 CDT