Importing Tables with BR*Tools


You can use BR*Tools  for Oracle to import tables from an operating system file.

This section describes how you import tables with BR*Tools.

For more information on the approach to table import, see Export/Import.

Do not use this procedure for the transport of database objects between databases.

Do not use this procedure for restore.



       1.      Start the procedure using BRGUI or BRTOOLS, or from the command line:

Ў        BRGUI or BRTOOLS:

                                                  i.       Choose Segment Management ® Import tables.

BRGUI or BRTOOLS displays the menu BRSPACE options for import tables, where you specify the options with which you call BRSPACE.

                                                ii.       Set the required options:

Menu Entry

Equivalent BRSPACE

Command Option

BRSPACE profile (profile)


Database user/password (user)


BRSPACE export run / dump file (export)

-f tbimport -x|-export

Confirmation mode (confirm)


Extended output (output)


Scrolling line count (scroll)


Message language (language)


BRSPACE command line (command)

This shows you the BRSPACE -f tbimport command that is to be executed using the current settings.

                                               iii.       Choose Continue.

BRGUI or BRTOOLS prompts you to start BRSPACE.

                                               iv.       Choose Continue to start BRSPACE.

Ў        Command line:


Enter at least the following command:

brspace –f tbimport

You can enter more parameters, including the table names, if required. For more information, see BRSPACE -f tbimport.

Whichever way you start the procedure – with BRGUI or BRTOOLS, or from the command line – you can use quick mode if you know the final object names, in this case the name of the BRSPACE export run or the export file name. For more information, see How to Use BR*Tools.

BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log.

       2.      If you have already entered the BRSPACE export run or the export file name, continue with step 5 (quick mode).

BRSPACE displays the Import tables main menu.

       3.      Choose Import tables.

BRSPACE displays the list of BRSPACE exports for import:

List Entry



List sequence number


BRSPACE export identifier – BRSPACE log name


Export date


Number of tables in export


Number of export dump files

Size [KB]

Total size of the export dump file(s)

       4.      Select an export run.

BRSPACE displays the menu Main options for import.

       5.      Set the required options:

Menu Entry


Import type (type)

-f tbimport -t|-type

Owners for export (owner)

-f tbimport -o|-owner

Tables for import (tables)

-f tbimport -t|-tables

Import table rows (rows)

-f tbimport -r|-rows

Import table indexes (indexes)

-f tbimport -i|-indexes

Import table constraints (constraints)

-f tbimport -c|-constraints

Import table grants (grants)

-f tbimport -g|-grants

       6.      When you have set the required options, choose Continue

BRSPACE displays the menu Additional options for import.

Menu Entry


Import buffer size in KB (buffer)

-f tbimport -b|-buffer

Commit after each array insert (commit)

-f tbimport -m|-commit

Ignore creation errors (ignore)

-f tbimport -n|-ignore

Max. size of dump file in MB (filesize) –

input only possible if the dump file is not from BRSPACE. For more information, see menu entry BRSPACE export run / dump file above.

-f tbimport -z|-filesize

Force table import (force)

-f tbimport -f|-force

IMP command

The IMP command that is to be executed using the current settings. For more information, see your Oracle documentation.

       7.      To start processing with the selected options, choose Continue.


Check the results in the BRSPACE logs.

·        The summary log space<DBSID>.logdisplays the return code.

·        The detail log s<encoded timestamp>.tbi displays the details.

For more information on how to view the logs with BR*Tools, see Showing Logs and Profiles with BR*Tools.

The parameter file, parfile.imp, is created in subdirectory <encoded timestamp> of the directory $SAPDATA_HOME/sapreorg. It contains the parameters for the Oracle import tool, IMP.