-f tbexport

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

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.

Function options:

·        -b|-buffer: specifies the export buffer size

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

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

·        -m|-compress: specifies whether table extents are compressed

Syntax: -m|-compress yes|no

Default: no

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

Syntax: -n|-consistent yes|no

Default: no

·        -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> specifies the name of the SAP owner

Default: no default in MCOD, otherwise the single SAP owner

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

Syntax: -r|-rows yes|no

Default: yes

·        -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 [<owner>.]<table>|[<owner>.]<prefix>%|%|
[<owner>.]<prefix>*|*|<table_list>

Wildcards: “%” means preselect, “*” means final select

For more information on 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.