Tweet
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/[email protected]).
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
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/[email protected]).
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