Template:SQWareProduction sqwora PartialRefresh.ksh presentation
Refresh of a tables list for one schema by exp/imp
Actions:
- Makes export of distant tables to refresh by ssh (list contained in a file)
- Retrieve dump file by scp
- Drop tables to refresh
- Makes import
The script can also:
- change of unix users target/source
- send email report of refresh
- run shell script after load