Template:SQWareProduction sqwora PartialRefresh.ksh presentation: Difference between revisions
Jump to navigation
Jump to search
m Updated by Expdbtools |
m Updated by BatchUser |
||
| Line 2: | Line 2: | ||
<br>Actions: | <br>Actions: | ||
* Makes export of distant tables to refresh by ssh (list contained in a file) | * Makes export of distant tables to refresh by ssh (list contained in a file) | ||
* Retrieve | * Retrieve Dump file by scp | ||
* Drop tables to refresh | * Drop tables to refresh | ||
* Makes import | * Makes import | ||
| Line 8: | Line 8: | ||
* change of unix users target/source | * change of unix users target/source | ||
* send email report of refresh | * send email report of refresh | ||
* run shell script after | * run shell script after Load | ||
Revision as of 18:46, 5 April 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