Difference between revisions of "Template:SQWareProduction sqwora Expdp.ksh presentation"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
 
m (Updated by BatchUser)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 
+
<br>Generate Oracle expdp
 +
<br>Type of export can be
 +
* full
 +
* schema
 +
* structure (full rows=no)
 +
* parfile
 +
* tables
 +
<br>Script makes purge of old generation automatically
 +
<br>You can also choose:
 +
* different retention policy
 +
* type of compression
 +
<br>      - gzip
 +
<br>      - bzip2
 +
<br>      - compress
 +
<br>      - none
 +
* different directory to put dump file
 +
* different directory to put log file
 +
* copy dump file

Latest revision as of 23:25, 21 April 2018


Generate Oracle expdp
Type of export can be

  • full
  • schema
  • structure (full rows=no)
  • parfile
  • tables


Script makes purge of old generation automatically
You can also choose:

  • different retention policy
  • type of compression


- gzip
- bzip2
- compress
- none

  • different directory to put dump file
  • different directory to put log file
  • copy dump file