Hi,
I have a materialized view on a table and if i add a new column to the base tables do i need to recreate the materialized view or will the newly added column gets populated in the materiaLized view automatically.
Thanks
Printable View
Hi,
I have a materialized view on a table and if i add a new column to the base tables do i need to recreate the materialized view or will the newly added column gets populated in the materiaLized view automatically.
Thanks
You have to recreate it.
A View is a [b}View[/b] is a view
It could have comprised of some columns of your table,
all columns of your table or multiple columns from multiple tables. So if u want to add a column, you have to recreate it !