Oracle : Upgrade to 10.2.0.5 hit ORA-00600: internal error code, arguments: [voprrfjcvm: Original Table Not F], [], [], [], [], [], [

Encounter the following after upgrading database to 10.2.0.5

ORA-00600: internal error code, arguments: [voprrfjcvm: Original Table Not F], [], [], [], [], [], [

After checking with Oracle Support found that we have hit a BUG :(

BUG#9951326 duplicate of BUG#6963442. This is fixed in version 11.2.0.1


Solution /workaround :

1. set undocumented parameter

alter session set "_fix_control"='6146906:off' scope=both;
OR
alter session set "_complex_view_merging"=false scope=both;

or apply interim patch 6963442

patch is available in version 10.2.0.5 and 11.1.0.7.0

Patch readme :
https://updates.oracle.com/Orion/Services/download?type=readme&aru=11691458