Home » SQL & PL/SQL » SQL & PL/SQL » Materializd (Oracle 9i)
Materializd [message #446607] Tue, 09 March 2010 09:53 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi All,

I have created a materliazed view like this

CREATE MATERLIAZED VIEW mv
REFRESH FAST START WITH sysdate
NEXT syadate+1
AS
SELECT * FROM emp;

It will refresh the data every 24 hours.

But mean while i want to refresh the data by 4 P.M manually because of some urgent work.


Please help me.
Re: Materializd [message #446608 is a reply to message #446607] Tue, 09 March 2010 09:56 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
dbms_mview.refresh
Previous Topic: Overloading problem
Next Topic: Any body help us.............?
Goto Forum:
  


Current Time: Fri Dec 09 06:18:51 CST 2016

Total time taken to generate the page: 0.09404 seconds