Template:SQWareProduction sqwora Expdp.ksh help

From Wiki_dbSQWare
Revision as of 21:42, 9 September 2018 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Sourcing sqwora_Global.lib v4.0.09 SQWareProduction for Oracle (dbSQWare) ... 

Usage: sqwora_Expdp.ksh [-h] -I <instance> -T <type_exp> [+ options]

DESCRIPTION
   sqwora_Expdp.ksh expdp script
SUPPORT
   Oracle supported versions: 10gR2 <= v <= 12cR1

PARAMETERS
     -I  instance       : Target instance for expdp.
     -T  type_exp       : Type of expdp (full,schema,structure,parfile,tables).
OPTIONS
     -h  help           : Display the full usage.
     -s                 : Display samples of usage.
     -H   nb_gen        : Number of generations to keep (default: 1).
     -P  Nb threads     : Number of threads in parallel (by default 2).
     -FU  owner         : Schema to expdp.
     -Pdb pdb_name      : pdb_name for multitenant.
     -PAR parfile       : Parfile to use.
     -OPT option        : Option to add at the expdp command.
     -ZIP extension     : Compressor extension gz,bz2,Z,none (default: none).
     -FRT return_code   : Force return code value on error.
     -AddMail email     : Email Address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -NoConsistent      : Remove 'flashback_time=systimestamp' option.
     -RD  directory     : Expdp directory (default /$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/expdp).
     -PutInf  u@h:path  : user@host:path to push dump on distant host.
     -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser@$ORACLE_SID ).
     -Sysdba            : '/ as sysdba' connection until $gvsqw_DbaUser.
     -NoMail            : Desactivate sendmail on error to pmexpdba@gmail.com (by default, send on error).
     -Exec              : Execute expdp (default, display generated commands).