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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
 
m (Updated by BatchUser)
 
Line 1: Line 1:
<br>Generate Oracle expdp
+
<br>Generate Oracle expdp for schemas and structure
<br>Type of export can be
 
* full
 
* schema
 
* structure (full rows=no)
 
* parfile
 
* tables
 
 
<br>Script makes purge of old generation automatically
 
<br>Script makes purge of old generation automatically
 
<br>You can also choose:
 
<br>You can also choose:

Latest revision as of 16:12, 7 April 2024


Generate Oracle expdp for schemas and structure
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