Re: can an ORA-600 error cause a DB shutdown

Mistton wrote:
> plan on using an IOT with compressed PK however said this bug
>
> Bug 2718937 OERI:6033 from SELECT on IOT with COMPRESSED PRIMARY KEY
> Queries on an IOT table with a compressed primary key
> may fail with ORA-600 [6033].
>
> can an ORA-600 cause the DB to shutdown? or just the select to fail

no, a select resulting in ora-600 can crash the database. I remember an ora-600 on
select * from v$pwfile_users, and the database crashed. Whether this particular ora-600 can crash the database, I don't know.

-- 
Sybrand Bakker
Senior Oracle DBA