All,
Here's a simple script that I use to quickly update materialized views within Oracle. You'll need to edit the script and update the connection parameters to work within your environment (username/password@otmdb).
Usage: mw-UpdateOracleMV.bat <mv_name>
where <mv_name> is the name of the materialized view that you'd like to update.
NOTE: There is one serious issue with this script - in that it keeps the Oracle username and password in clear-text, within the script. There are several ways around this, including passing them in as parameters instead. Please ensure that this meets the security requirements of your organization/environment before using.
File Download: mw-UpdateOracleMV.bat.zip
Hope this helps!
--Chris
Linear Mode
