Can someone help me out?
Trying to figure out a couple of things.
First, I have a materialized view, i need to refresh everyday at 6am.
create materialized view sometable as
select * from sometable
Complete refresh, the remote database is non-oracle.
Can i have multiple materialized views refresh at the same time at 6am? or should i do them one after another. In that case, how can I start the materialized view refresh to execute one after another?