| alter materialized view [message #216000] |
Wed, 24 January 2007 10:17  |
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 #216126 is a reply to message #216000] |
Thu, 25 January 2007 02:44  |
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'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
