|
|
| Line 1: |
Line 1: |
| | <pre> | | <pre> |
| − | Sourcing sqwora_Global.lib v2023.09 SQWareProduction for Oracle (dbSQWare) ... | + | Sourcing sqwora_Global.lib v2024.01 SQWareProduction for Oracle (dbSQWare) ... |
| − | | |
| − | #Standard help for script sqwora_ExpdpAllPDB.ksh:
| |
| − | | |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -h
| |
| − | #Display online help for this script
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -Locale en -h
| |
| − | #Display online help for this script with forcing of the 'fr' locale (default locale managed by the variable gvsqw_Locale)
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -s
| |
| − | #Display usage examples for this script
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -AddMail 'mymail1@mydomaine.com,mymail2@mydomaine.com'
| |
| − | #Add the mail list to the default address managed by the variable gvsqw_GlobalMail
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -SendReport
| |
| − | #Send the log by email at the end of the treatment even if there is no error
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -I $ORACLE_SID -T <ExpType> -NoMail
| |
| − | #Deactivate sendmail on error to $gvsqw_GlobalMail (by default, send on error)
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -I $ORACLE_SID -T <ExpType> -DIR <DirExport> -ZIP <ZipExtension> -Exec
| |
| − | #Execute generated commands and use export directory <DirExport> and compress them (gz,bz2,Z,none)
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -I $ORACLE_SID -T <ExpType>
| |
| − | #Generate commands but don't execute them !
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -I $ORACLE_SID -T schema -O <SchemaName> -Exec
| |
| − | #Export schema <SchemaName>
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -I $ORACLE_SID -T schema -O <SchemaName> -PutInf <user@host:path> -Exec
| |
| − | #Export schema <SchemaName> and copy dump files
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -I $ORACLE_SID -T <ExpType> -H <HostName> -FRT <NumericValue> -Exec
| |
| − | #Force return code to '<NumericValue>' on error (if no error, exit 0!)
| |
| − | #You can also force return code of this script on all your
| |
| − | #environnement if you set the variable: $gvsqw_ForcedReturnCodeScript_sqwora_ExpdpAllPDB=<NumericValue>
| |
| − | #in configuration file $gvsqw_OraBin/../etc_cust/sqwora_GlobalVar.cfg
| |
| − | | |
| − | $gvsqw_OraBin/sqwora_ExpdpAllPDB.ksh -I $ORACLE_SID -P <NumericValue> -Exec
| |
| − | #Run sqwora_ExpdpAllPDB.ksh script with a parallel degree of '<NumericValue>'
| |
| − | #Use by default the variable gvsqw_NbThreadXXX in $gvsqw_OraBin/../etc/sqwora_GlobalVar.cfg
| |
| − | #You can change this default on all your environnement if you set this variable
| |
| − | #in configuration file $gvsqw_OraBin/../etc_cust/sqwora_GlobalVar.cfg
| |
| | </pre> | | </pre> |
