Hi,

DB: Oracle 7.3.4.0
OS: Compaq Tru64Unix v4.0 D

I am getting ORA-600 while running query against one table. I got the following output after running "analyze table validate structure cascade"

Dump file /ora51/app/oracle/admin/cdsbp/udump/ora_9226.trc
Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Production
With the distributed option
PL/SQL Release 2.3.4.0.0 - Production
ORACLE_HOME = /ora51/app/oracle/product/7.3.4
System name: OSF1
Node name: puma.qntm.com
Release: V4.0
Version: 878
Machine: alpha
Instance name: cdsbp
Redo thread mounted by this instance: 1
Oracle process number: 26
Unix process pid: 9226, image: oraclecdsbp

*** 2001.08.20.15.38.51.931
*** SESSION ID:(10.1860) 2001.08.20.15.38.51.886
Table/Index row count mismatch
table 9949285 : index 9949298, 0
Index root = dba: 0x2c019935

How should I know from this trace file, which index to be rebuilt ? Or do I need to rebuild all indexes on this table??

Appreciate all the help.

Sanjay