Template:SQWareProduction sqwora SchemaRefresh.ksh presentation

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