Difference between revisions of "Template:SQWareProduction sqwora SchemaRefresh.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 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
