Home » SQL & PL/SQL » SQL & PL/SQL » alter materialized view
alter materialized view [message #216000] Wed, 24 January 2007 10:17 Go to next message
Messages: 25
Registered: July 2006
Junior Member
Hi Friends

I have a senario where we are trying to to alter materialized view
so that the view can be refreshed manually insted of automatic.
While we created it was automatic. But the requirement now is manual

I am using below statement to alter MVIEW but it is not wokring.
Can anyone help me how to make it manual refresh

alter materialized view mvw_table_name_dev REFRESH ON DEMAND

Re: alter materialized view [message #216012 is a reply to message #216000] Wed, 24 January 2007 11:28 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8727
Registered: November 2002
Location: California, USA
Senior Member
You will probably have to drop it, then recreate it.
Re: alter materialized view [message #216126 is a reply to message #216000] Thu, 25 January 2007 02:44 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It should work (according to the docs)
Are you on 8i or 9i?

Does it give an error?

What results does this query give:
SELECT NAME,TYPE,refresh_mode 

Previous Topic: Databae connecting problem after creating the trigger-reg
Next Topic: convert date
Goto Forum:

Current Time: Wed Jul 26 06:17:07 CDT 2017

Total time taken to generate the page: 0.07770 seconds