Template:SQWareProduction sqwora SchemaRefreshExpdp.ksh presentation

From Wiki_dbSQWare
Revision as of 17:58, 25 March 2018 by BatchUser (talk | contribs) (Updated by BatchUser)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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)
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwora_SchemaRefreshExpdp.ksh_presentation&oldid=10284"