Data-engineering

You cannot ALTER the column structure of an implicit Materialized View directly. Here is how to convert it to an explicit TO target table first, run your ALTER, and rebuild the view without POPULATE or data loss.