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
basirana
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

Thanks
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: 8621
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
JRowbottom
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 
FROM   USER_SNAPSHOTS;


Try 'ALTER <mviev> REFRESH FORCE ON DEMAND'
Previous Topic: Databae connecting problem after creating the trigger-reg
Next Topic: convert date
Goto Forum:
  


Current Time: Fri Dec 02 18:41:37 CST 2016

Total time taken to generate the page: 0.20847 seconds