Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Materialized Views query without refresh?

Materialized Views query without refresh?

From: Denham Eva <EVAD_at_TFMC.co.za>
Date: Wed, 1 Jun 2005 13:29:34 +0200
Message-ID: <B822F724868AE8419D78F162BE7C2DB601B14B63@cent12000.tfmc.co.za>


Hello Listers,

Our database has some materialized views, which are set 'refresh forced'.
In discussion I was asked whether it was possible to query the view without it doing the refresh process, so that the snapshot would not be refreshed.=20
I had to answer that I was not certain this was possible, does anyone know if this is possible??

Many Thanks
Denham

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 01 2005 - 08:04:30 CDT

Original text of this message

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