Template:SQWareProduction sqwora SchemaRefresh.ksh presentation: Difference between revisions
Jump to navigation
Jump to search
m Updated by Expdbtools |
m Updated by BatchUser |
| (One intermediate revision by the same user not shown) | |
(No difference)
| |
Latest revision as of 21: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