Difference between revisions of "Template:SQWareProduction sqwora PartialRefresh.ksh presentation"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
| (One intermediate revision by the same user not shown) | |
(No difference)
| |
Latest revision as of 20:29, 16 June 2014
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
