Re: Q... dbms_snapshot.refresh

From: Tim Gorman <tim_at_evdbt.com>
Date: Tue, 01 Mar 2005 15:00:00 -0700
Message-ID: <BE4A33F0.240BF%tim@evdbt.com>

Check [DBA|ALL|USER]_INDEXES; if they need to be rebuilt, STATUS will show "UNUSABLE"... on 3/1/05 1:28 PM, Bryan Wells at bunjibry_at_gmail.com wrote:

> we have materialized views being updated nightly by the refresh job.
> can someone tell me if that will rebuild the index and/or compute
> statistics associated to it?

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 01 2005 - 17:01:59 CST

This message: [ Message body ]
Next message: John Kanagaraj: "RE: Performance issue can't identify"
Previous message: Tony Vecchiet: "password and dblink mgmt tool"
In reply to: Bryan Wells: "Q... dbms_snapshot.refresh"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US