Modèle:SQWareProduction sqwora SchemaRefreshExpdp.ksh presentation

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 avant load
• run shell script apres load
• keep a table list (save/restore)