WTF?? Oh yeah, production uses COMPRESS. Chalk it up to bug 2421054, adding columns to a compressed table. Can you say patch anyone?
ALTER TABLE xyz ADD (z varchar2(20));
ORA-22856: cannot add columns to object tables
Thursday, July 07, 2005
Putting some changes into a 188.8.131.52 database. The table is range partitioned, but only has two simple fields (not object types). Adding columns in QA and DEV worked just fine, although they didn't have the volume that PROD does. I run my script and find: