-f tbimport

This BRSPACE function imports tables from an operating system file. For more information, see Importing Tables with BR*Tools.

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

Function options:

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

Syntax: -b|-buffer <size>

<size> specifies the size in KB

Default: 10240

·        -c|-constraints: specifies whether table constraints are imported

Syntax: -c|-constraints yes|no

Default: yes

·        -f|-force: forces import, even if SAP users are connected

Default: import is not forced if SAP user is connected

·        -g|-grants: specifies whether table grants are imported

Syntax: -g|-grants yes|no

Default: yes

·        -i|-indexes: specifies whether table indexes are created

Syntax: -i|-indexes yes|no

Default: yes

·        -m|-commit: specifies whether there is a commit after each array insert

Syntax: -m|-commit yes|no

Default: yes

·        -n|-ignore: specifies whether table creation errors are ignored

Syntax: -n|-ignore yes|no

Default: no

·        -o|-owner: defines the SAP owner of the tables to be imported – 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 imported

Syntax: -r|-rows yes|no

Default: yes

·        -t|-tables: specifies the table(s) to be imported

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

Default: none

·        -x|-export: specifies the export file

Syntax: -x|-export <exp_run>|<exp_dump>|<exp_dump_list>

Ў        <exp_run> specifies the BRSPACE run identifier, that is, the BRSPACE log name (s<coded_timestamp>.tbr)

Ў        <exp_dump> specifies the full path of the export dump file (not necessarily a BRSPACE export)

Ў        <exp_dump_list> specifies a list of export dump files (not necessarily BRSPACE export dump files)

Default: last BRSPACE export run

·        -y|-type specifies the type of import

Syntax: -y|-type full|tables|indexfile|show

Ў        full imports everything

Ў        tables imports individual tables as specified in the –t|-table parameter (see above)

Ў        indexfile dummy import – the DDL statements are written to an SQL file but there is no import

Ў        show shows the DDL statements in the export dump file but there is no import

Default: full

·        -z|-filesize specifies the dump file size

Syntax: -z|-filesize <size>

<size> specifies the maximal dump file size in MB

Default: value from BRSPACE export