VIEW :
- The view will not store any data.
- The view is mainly use for the security purpose.
- In view whenever the base table is dropped the view will not be accessible.
- In view DML operation can perform.(on simple views)
- The materialized view will store the data.
- The materialized view is mainly use for the performance purpose.
- In materialized view whenever the base table is dropped the view will accessible.
- In materialized view DML operation can not perform.
Please share your in case of any further clarification on above post.