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