Re: Adding a column to a replicated table
- From: Jared Still <jkstill@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Tue, 14 Jun 2005 08:00:51 -0700
On 6/14/05, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> wrote:
>
>
> Even if you had created it with an .. AS SELECT * ..., that would not
> automatically re-read the new column as the "local" definition would
> have been instantiated when you created the Materialized View.
> In my opinion, to add a column, you'd have to DROP and CREATE the MV.
> {but I hope, for your sake, to be proven wrong}.
> Hemant
I *believe* but have not verified that if you created the MV with a prebuilt
table, it would a matter of adding the column to the table and doing a
complete refresh.
It might be necessary to drop/create the MV in this case, but it is a fast
operation, and doesn't make it necessary to regrant permissions.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
