Re: howto detect which index is corrupted

There are a lot of ora-600 errors that do not have [12700] as the first argument.

Even if 12700 covered all cases of corruption (which I doubt it would), is this something everyone should know and be able to answer in a job interview?

Was this question in the job interview a tie-breaker/trick "type question" ? You know like the old "what is the command to create the system tablespace" ? Yeah right...

-- 
"joe minnich" <joeminnich_at_yahoo.com> wrote in message
news:Hv6dnfHbWM1ZwsyiU-KYgw_at_comcast.com...


> Dominica Leung wrote:

>

> > Hi All,

> >

> >   I went to an oracle DBA job interview the other day.

> > They ask this question.

> >

> > 1) When application running a SQL statement and

> > get ORA-600 errors.

> >

> > From the argument of ORA-600, the DBA go and look up

> > and find out "SQL can't be execute due to index corrupted".

> >

> > We know this SQL use 10 tables and

> > 15 indexes.

> > We have a UDUMP trace file. But look encrypted.

> >

> > How would you find out which indexes is corrupted?

> >

> > I can't answer it immediately, I told interviewer, I pass on this

> > question. But I am still curious even after I went home. I keep thinking

> > about it.

> >

> > Now, I am thinking you could

> > use 'Analyze table validate structure...' to verify.

> > But I read Oracle document, it says it will LOCK the table.

> >

> > The interviewer said Oracle probably has tools to

> > decrypte the dump file and find out which indexes.

> >

> > To me, I was thinking writing simple SQL

> > statement to access those indexes. But

> > interwiewer said "NO ALLOW".

> >

> > I wonder how to find out.

> > without using "Analyze table validate..".

> >

> >

> > Thank you in advance, any ideas/suggestion are welcome!!

> > I am still very curious about it.

> >

> >

> > Dominica Leun

>

> See the following article on http://metalink.oracle.com

>

> Doc ID:

> Note:155933.1

>

> Subject:

> Resolving an ORA-600 [12700] error

>

>