Difference between revisions of "Template:SQWareProduction sqwora SchemaRefresh.ksh presentation"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
| Line 2: | Line 2: | ||
<br>Actions: | <br>Actions: | ||
* Makes export of distant schema by ssh | * Makes export of distant schema by ssh | ||
| − | * Retrieve | + | * Retrieve Dump file by scp |
* Drop all objetcs of refreshed schema | * Drop all objetcs of refreshed schema | ||
* 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 before | + | * run shell script before Load |
| − | * run shell script after | + | * run shell script after Load |
Revision as of 17:46, 5 April 2014
Refresh one or more schemas by exp/imp
Actions:
- Makes export of distant schema by ssh
- Retrieve Dump file by scp
- Drop all objetcs of refreshed schema
- Makes import
The script can also:
- change of unix users target/source
- send email report of refresh
- run shell script before Load
- run shell script after Load
