>>"Is this a correct syntax? Does it refresh my view every hour
for eternity? or just the next 1 hr one time only?"
It is correct... as long as you have a materialized view log for the master table.
It will refresh the MW one hour after it finishes refreshing each time.
HTH.
Cheers.
Carlos.




Reply With Quote