-f tbexport

This BRSPACE function exports tables into an operating system file. For more information, see Exporting Tables with BR*Tools and Special Export and Import Functions with BRSPACE.

BRSPACE now supports the Oracle Data Pump tool for export, which is called “expdp” in this section. The conventional export is called “exp”.

Function options:

• -b|-buffer: specifies the export buffer size for exp

  Syntax: -b|-buffer <size>

  <size> specifies the size in KB

  Default: 10240

• -c|-constraints: specifies whether table constraints are exported

  Syntax: -c|-constraints yes|no

  Default: yes

• -d|-direct: specifies whether direct path is used for the export mode with exp

  Syntax: -d|-direct yes|no

  Default: yes

• -e|-triggers: specifies whether table triggers are exported

  Syntax: -e|-triggers yes|no

  Default: yes

• -f|-force: forces export, even if SAP users are connected

  Default: export is not forced if SAP user is connected

• -g|-grants: specifies whether table grants are exported

  Syntax: -g|-grants yes|no

  Default: yes

• -i|-indexes: specifies whether table indexes are exported

  Syntax: -i|-indexes yes|no

  Default: yes

• -l|-utility: specifies whether the export uses the original export or Data Pump tool

  Syntax: -l|-utility exp|expdp

  Default: expdp for Oracle 11g or higher; exp for Oracle 10g

  exp means that the export uses the exp tool

  expdp means that the export uses the Data Pump tool

• -m|-compress: specifies whether table extents or data are compressed

  Syntax: -m|-compress all|data|meta|no|yes

  all means meta plus data, only for expdp and Oracle 11g or higher

  data means that table rows are compressed, only for expdp and Oracle 11g or higher

  meta means that metadata is compressed, only for expdp

  yes means that table extents are compressed, only

  Default: no for expdp, yes for exp

• -n|-consistent: specifies whether the export is consistent to a single point-in-time

  Syntax: -n|-consistent yes|no

  Default: no

  Caution

  If you use this option, you cannot use the OPS$ mechanism to connect the database. For more information, see -u|-user.

• -o|-owner: defines the SAP owner of the tables to be exported - useful in Multiple Components in One Database (MCOD) configurations

  Syntax: -o|-owner <owner>|<owner_list>|all|full

  <owner> or <owner_list> specifies the name of the SAP owner or owners

  all specifies all SAP owners

  full specifies full database export

  Default: all SAP owners in MCOD, otherwise the single SAP owner

• -p|-parallel: specifies the degree of parallelism for the export with expdp

  Syntax: -p|-parallel <degree>

  Default: 1

• -pp|-pass_pump|-PP|-PASS_PUMP: this BRSPACE command option specifies the Oracle Data Pump password for the encryption of export dumps. If the password is not specified on the command line, BRSPACE prompts for it interactively - either concealed (for -pp|-pass_pump) or transparently via standard input (for -PP|-PASS_PUMP). In the second case (transparent), there is the possibility of automatically transferring the Data Pump password to BRSPACE via a program or script. For more information, see SAP Note 1324930 .

  Syntax: -pp|-pass_pump|-PP|-PASS_PUMP [<password>]

• -r|-rows: specifies whether table rows are exported

  Syntax: -r|-rows yes|no|only

  Default: yes

  only means that only data is exported for expdp

• -s|-tablespace: specifies the tablespace of the tables to be exported

  Syntax: -s|-tablespace <tablespace>|<tablespace list>

  <tablespace> or <tablespace list> specifies the tablespace name

  Default: none

• -t|-tables: specifies the table(s) to be exported

  Syntax: -t|-tables all|allsel|[<owner>.]<table>|

  [<owner>.][<prefix>]%[<suffix>]|

  [<owner>.][<prefix>]*[<suffix>]|<table_list>

  where:

  all or “%” means preselect

  allsel or “*” means final select:

  For more information about wildcards for preselect and select, see Selecting Objects in Segment Management with BR*Tools.

  Default: all (preselection)

• -u|-dumpdir: specifies the export dump directory

  Syntax: -u|-dumpdir <dir>

  <dir> specifies the dump directory name

  Default: work directory, usually $SAPDTA_HOME/sapreorg

• -z|-filesize specifies the dump file size

  Syntax: -z|-filesize <size>

  <size> specifies the maximal dump file size in MB

  Default: 2000/20000. 2000 is the normal maximal dump file size. However, if your operating system has large file support, the default is 20000.