hi, Malhi,
As per the op it is not required to rebuild the index the Blevel is less
than 3.
If you want to rebuild the command is ' alter index indexname rebuild';
Thanks
Regards
Sudhakar
----- Original Message -----
From: "Rupinder Malhi" <Rupinder.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, April 21, 2004 9:45 AM
Subject: need help to Rebuilt Index
>
> Hi Gurus,
>
> This is my first email to lazydba gurus.
>
> I am going to rebuilt my production indexes. I got a script from metalink
to
> check which indexes are corrupted. The op of the script I am pasting
below.
>
>
****************************************************************************
> **********
>
> Owner Index Name % Deleted Entries
> Blevel Distinctiveness
> --------------- --------------------------------------- -----------------
> ------ ---------------
> OPC_OP OPCX_ANNO_NUM 100 1 0
> OPC_OP OPC_MESSAGE_MSGGRP 90.196 1 88.889
> OPC_OP OPC_MESSAGE_NODES 93.644 2 84.746
> OPC_OP OPC_TEMPL_ON_NODE 27.411 1 11.997
> OPC_OP SYS_C001009 20.598 1 0
> OPC_OP SYS_C001130 33.333 0
> 0
> OPC_OP SYS_C001294 91.228 1
> 0
> OPC_OP SYS_C001330 85.022 1
> 0
> OPC_OP SYS_C001333 94.913 1
> 0
> OPC_OP SYS_C001338 100 1 0
> OPC_OP SYS_C001342 100 1 0
> OPC_OP SYS_C001347 100 0 0
>
> PL/SQL procedure successfully completed.
>
>
****************************************************************************
> ****************************************************
> My question is:
> 1. Do I need to rebuilt all these indexes OPC_ and SYS_.
> 2. which cmd I have to use to rebuilt the above indexes.
>
> Thanks in advance
>
> Regards
> Rupinder
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page