Re: Q... dbms_snapshot.refresh

From: Tim Gorman <tim@xxxxxxxxx>
To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 01 Mar 2005 15:00:00 -0700

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@xxxxxxxxx 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

References:

Q... dbms_snapshot.refresh
From: Bryan Wells

Other related posts:

» Q... dbms_snapshot.refresh
» RE: Q... dbms_snapshot.refresh
» Re: Q... dbms_snapshot.refresh

Browse oracle-l