Is that possible to change materialized view query without droping it and re-acreting it? F.
No you cannot. But if you want to change a refresh rate you can rebuild it: http://www.dbaoncall.net/scripts/gen...snapshots.html
Alexander Geldutes Home-page: http://www.daboncall.net
Forum Rules