Template:SQWareProduction sqwora SchemaRefreshExpdp.ksh presentation: Difference between revisions
Jump to navigation
Jump to search
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)