Difference between revisions of "Template:SQWareProduction sqwora SchemaRefreshExpdp.ksh presentation"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 1: | Line 1: | ||
| − | + | <br>Refresh one or more schemas by expdp/impdp | |
| + | <br>Actions: | ||
| + | * Makes export of distant schema by ssh | ||
| + | * Retrieve dump file by scp | ||
| + | * Drop all objetcs of refreshed schema | ||
| + | * Makes import | ||
| + | <br>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 | ||
| + | * keep a table list (save/restore) | ||
Latest revision as of 18:58, 25 March 2018
Refresh one or more schemas by expdp/impdp
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
- keep a table list (save/restore)
