how to refresh the mv structure if master table structure has changed
Hi all,
I have a master table and a Mview based on this master table. When the column in Master table (also in Mview) has enlarged the column width, i.e. from varchar2(10) to varchar2(20). Do we have a alter mview SQL to refresh the MView structure?
Of course, I can drop the MView and recreate it again. But do we have another method to complete this?
Thanks,
Kenny.
I have a master table and a Mview based on this master table. When the column in Master table (also in Mview) has enlarged the column width, i.e. from varchar2(10) to varchar2(20). Do we have a alter mview SQL to refresh the MView structure?
Of course, I can drop the MView and recreate it again. But do we have another method to complete this?
Thanks,
Kenny.
0