Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yipchunyu
Yak Posting Veteran
80 Posts |
 Posted - 2011-05-16 : 22:40:52
|
| Dear all,I run below SQL via Oracle's SQL developer to refresh the materialized view but can't make it run via DTS. Any help?exec dbms_mview.refresh( 'MV_TABLE1', 'C' ); |
|
|
yipchunyu
Yak Posting Veteran
80 Posts |
Posted - 2011-05-16 : 23:29:53
|
| Seem to find the solution:{call dbms_mview.refresh( 'MV_TABLE1', 'C' )} |
 |
|
|
|
|
|
How refresh materialized view via DTS