Template:SQWareProduction sqwora Export.ksh help: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older edit
m Updated by BatchUser
No edit summary
 
(36 intermediate revisions by the same user not shown)
Line 1: Line 1:
<pre>
<pre>
Sourcing sqwora_Global.lib v2020.07 SQWareProduction for Oracle (dbSQWare) ...  
Sourcing sqwora_Global.lib v2025.10 SQWareProduction for Oracle (dbSQWare) ...  


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


DESCRIPTION
DESCRIPTION
   sqwora_Export.ksh export script
   sqwora_Export.ksh export script
SUPPORT
SUPPORT
   Oracle supported versions: 9iR2 <= v <= 19c
   Oracle supported versions: 9iR2 <= v <= 23ai


PARAMETERS
PARAMETERS
Line 13: Line 13:
     -T  type_exp      : Type of export (full,schema,structure,parfile,tables).
     -T  type_exp      : Type of export (full,schema,structure,parfile,tables).
OPTIONS
OPTIONS
     -h help          : Display the full usage.
     -h                 : Display the full usage.
     -s                : Display samples of usage.
     -s                : Display samples of usage.
     -H  nb_gen        : Number of generations to keep (default: 1).
     -HI  nb_gen        : Number of generations to keep (by default: 1).
     -FU  owner        : Schema to export.
     -FU  owner        : Schema to export.
     -Pdb pdb_name      : pdb_name for multitenant.
     -Pdb pdb_name      : pdb_name for multitenant.
     -PAR parfile      : Parfile to use.
     -PAR parfile      : Parfile to use.
     -ZIP extension    : Compressor extension gz,bz2,Z,none (default: gz).
     -ZIP extension    : Compressor extension gz,bz2,Z,none (by default: gz).
     -FRT return_code  : Force return code value on error.
     -FRT return_code  : Force return code value on error.
     -AddMail email     : Email address to add at 'pmexpdba@gmail.com'.
     -AddMail   email   : Email address to add at 'demo-sqwarebox@dbsqware.com'.
     -Consistent        : Export full in 'consistent=y'.
     -Consistent        : Export full in 'consistent=y'.
     -SendReport        : Send execution log report.
     -SendReport        : Send execution log report.
     -DIR dir_dump     : Export directory (default: /$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/exp).
     -RD  dir_dump     : Export directory (by default: /$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/exp).
     -DLOG dir_log      : Log directory (default: /$(echo $HOME|cut -d/ -f2)/backup/${ORACLE_SID}/exp/log).
     -DLOG dir_log      : Log directory (by default: /$(echo $HOME|cut -d/ -f2)/backup/${ORACLE_SID}/exp/log).
     -Sysdba            : '/ as sysdba' connection instead of $gvsqw_DbaUser.
     -Sysdba            : '/ as sysdba' connection instead of $gvsqw_DbaUser.
     -NoMail            : Deactivate sendmail on error to pmexpdba@gmail.com (by default, send on error).
     -NoMail            : Deactivate sendmail on error to demo-sqwarebox@dbsqware.com (by default, send on error).
     -Locale   locale   : Force Locale for help display (fr,en).
     -Locale   locale : Force Locale for help display (fr,en).
     -Exec              : Execute export (default, display generated commands).
     -Exec              : Execute export (by default, display generated commands).


</pre>
</pre>

Latest revision as of 16:20, 10 October 2025

Sourcing sqwora_Global.lib v2025.10 SQWareProduction for Oracle (dbSQWare) ... 

Usage: sqwora_Export.ksh [-h] -I <instance> -T <ExpType> [+ options]

DESCRIPTION
   sqwora_Export.ksh export script
SUPPORT
   Oracle supported versions: 9iR2 <= v <= 23ai

PARAMETERS
     -I  instance       : Target instance to export.
     -T  type_exp       : Type of export (full,schema,structure,parfile,tables).
OPTIONS
     -h                 : Display the full usage.
     -s                 : Display samples of usage.
     -HI  nb_gen        : Number of generations to keep (by default: 1).
     -FU  owner         : Schema to export.
     -Pdb pdb_name      : pdb_name for multitenant.
     -PAR parfile       : Parfile to use.
     -ZIP extension     : Compressor extension gz,bz2,Z,none (by default: gz).
     -FRT return_code   : Force return code value on error.
     -AddMail   email   : Email address to add at 'demo-sqwarebox@dbsqware.com'.
     -Consistent        : Export full in 'consistent=y'.
     -SendReport        : Send execution log report.
     -RD   dir_dump     : Export directory (by default: /$(echo ${HOME}|cut -d/ -f2)/backup/${ORACLE_SID}/exp).
     -DLOG dir_log      : Log directory (by default: /$(echo $HOME|cut -d/ -f2)/backup/${ORACLE_SID}/exp/log).
     -Sysdba            : '/ as sysdba' connection instead of $gvsqw_DbaUser.
     -NoMail            : Deactivate sendmail on error to demo-sqwarebox@dbsqware.com (by default, send on error).
     -Locale    locale  : Force Locale for help display (fr,en).
     -Exec              : Execute export (by default, display generated commands).
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwora_Export.ksh_help&oldid=35443"