Modèle:SQWareProduction sqwora SchemaRefresh.ksh presentation
Révision datée du 14 avril 2019 à 18:05 par BatchUser (discussion | contributions) (Updated by BatchUser)
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 avant load
- run shell script apres load