Streams and CDC Capture error - ORA-24335 but tables have less than 1000 columns
Database Version: 11.2.0.3
We have upgraded all of our non-production databases from 10.2.0.5 to 11.2.0.3 and not encountered this problem. We upgraded our production databases to 11.2.0.3 and started encountering this error:
In the Streams and CDC Capture processes, the following error occurs:
Streams CAPTURE CP02 for CDC$C_CDCCHGSOURCE with pid=110, OS id=23456 stopped
Errors in file /oradata/PRDORA01/admin/bdump/diag/rdbms/prdora01/PRDORA01/trace/PRDORA01_cp02_23456.trc:
ORA-24335: cannot support more than 1000 columns
From the .trc file:
++ KRVXOA Dump Begin:
Object Number: 1351290 BaseObjNum: 1351290 BaseObjVersion: 1
Object Name: GEMINI.PRJ_PROJECTS_EXT2_STRING Type: 2
User Cols: 981, Int Cols: 981, Kernel Cols: 981