Re: Refreshing a long-running Materialized View with an Index
From: kes <abirch_at_gmail.com>
Date: Wed, 28 Oct 2009 11:53:03 -0700 (PDT)
Message-ID: <2a994479-ff20-491f-b221-c42c72942d5b_at_i12g2000prg.googlegroups.com>
On Oct 28, 1:29 pm, Andreas Piesk <alphapapa..._at_googlemail.com> wrote: <snip/>
> exec dbms_mview.refresh( 'my_materialized_view', 'C', atomic_refresh
> => false );
>
> this way, all indexes on the table are set unusable and the table gets
> truncated and loaded very fast with insert /*+append*/. afterwards the
> indizes will be rebuilded automatically.
Date: Wed, 28 Oct 2009 11:53:03 -0700 (PDT)
Message-ID: <2a994479-ff20-491f-b221-c42c72942d5b_at_i12g2000prg.googlegroups.com>
On Oct 28, 1:29 pm, Andreas Piesk <alphapapa..._at_googlemail.com> wrote: <snip/>
> exec dbms_mview.refresh( 'my_materialized_view', 'C', atomic_refresh
> => false );
>
> this way, all indexes on the table are set unusable and the table gets
> truncated and loaded very fast with insert /*+append*/. afterwards the
> indizes will be rebuilded automatically.
Thank you. I'll use this and the synonym. Received on Wed Oct 28 2009 - 13:53:03 CDT