Oracle Database Discussions

Hello All,

We just upgraded our production database 2 days ago, from 10.2.0.4 to 11.2.0.3. Day before upgrade, we had our application teams recompiled all their invalid objects to save time during upgrade. Now after upgrade I found bunch of views in INVALID status. I tried recompiling them, but getting the error "ORA-01730: invalid number of column names specified".

This is what I found about the error. "The number of column names specified in a CREATE VIEW statement did not correspond to the number of columns listed in the SELECT clause. If column names are specified in a CREATE VIEW statement, exactly one name must be specified for each column or expression in the SELECT clause".

I verified the DDLs of those views and I found few column is SELECT are missing in view structure also few columns in view structure are missing from SELECT. There are different number of columns in view structure and SELECT, which supports the above information.

My question is why it was not a problem in 10g?? I checked all the objects day before upgrade and they were valid. These views were created in 2010, they were not created just before upgrade. Is this related to any new features of 11g??

Thanks,
KRMR.