That only drops the column off the under lying table - if you check DBA_OBJECTS for the view it will be invalid, and the recompile will fail. I'm pretty sure you need to drop and re-create it