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
Oracle LazyDBA home page