Syntax documentation-f tbimport

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

BRSPACE now supports the Oracle Data Pump tool for import, which is called “impdp” in this section. The conventional import is called “imp”.

Note Note

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

End of the note.

Function options:

  • -a|-action: specifies the processing action for existing tables with impdp

    Syntax: -a|-action skip|append|truncate|replace

    skip leaves the table as it is and moves on to the next object.

    append loads rows from the source and leaves existing rows unchanged.

    truncate deletes existing rows and then loads rows from the source.

    replace drops the existing table and then creates and loads it from the source.

    This is only supported for impdp.

    Default: skip

  • -b|-buffer: specifies the import buffer size for imp

    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

  • -e|-triggers: specifies whether triggers are imported with impdp

    Syntax: -e|-triggers 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 with imp

    Syntax: -m|-commit yes|no

    Default: yes

  • -n|-ignore: specifies whether table creation errors are ignored with imp

    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_list>

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

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

  • -p|-parallel: specifies the degree of parallelism for the import with impdp

    Syntax: -p|-parallel <degree>

    Default: 1

  • -pp|-pass_pump|-PP|-PASS_PUMP: this BRSPACE command option specifies the Oracle Data Pump password for the decryption of export dumps during the import. 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 1324930Information published on SAP site.

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

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

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

    only specifies that only data is imported for impdp

    Default: yes

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

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

    Default: all

  • -x|-export: specifies the export file

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

    • <exp_run> specifies the BRSPACE run identifier where the export dump file was created, 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|sqlfile

    • 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 the text file indfile.sql in the working directory but there is no import. Only supported for imp.

    • show shows the DDL statements in the export dump file but there is no import. Only supported for imp.

    • sqlfile means that DDL statements from the objects in the export dump file are stored in the text file sqlfile.sql in the working directory. No data is imported. Only supported for impdp.

    Default: full

  • -z|-filesize specifies the dump file size for imp

    Syntax: -z|-filesize <size>

    <size> specifies the maximal dump file size in MB

    Default: value from BRSPACE export