Show TOC

Syntax documentation-f tbexport Locate this document in the navigation structure

This BRSPACE function exports tables into an operating system file. For more information, see Exporting a Table 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”.

Note Note

Since this function directly uses the Oracle table export tool EXP, see the Oracle documentation for more information on most of the parameters listed below.

End of the note.

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 Data Pump tool

    Syntax: -l|-utility exp|expdp

    Default: exp

    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 yes|no|meta

    Default: yes

    yes is only for exp

    meta means that metadata is compressed, only for expdp

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

    Syntax: -n|-consistent yes|no

    Default: no

    Caution Caution

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

    End of the caution.

  • -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: no default 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

  • -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: none, since you must always select a table

  • -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.