Importing Tables with BR*Tools

Posted on by

Use

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.

Procedure

…

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

¡        BRGUI or BRTOOLS:

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

  1. Set the required options:
Menu Entry Equivalent BRSPACE

Command Option
BRSPACE profile (profile) -p|-profile
Database user/password (user) -u|-user
BRSPACE export run / dump file (export) -f tbimport -x|-export
Confirmation mode (confirm) -c|-confirm
Scrolling line count (scroll) -s|-scroll
Message language (language) -l|-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.

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

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

  1. Choose Import tables.

BRSPACE displays the list of BRSPACE exports for import:

List Entry Meaning
Pos. List sequence number
Run BRSPACE export identifier – BRSPACE log name
Date Export date
Tables Number of tables in export
Dumps Number of export dump files
Size [KB] Total size of the export dump file(s)
  1. Select an export run.

BRSPACE displays the menu Main options for import.

  1. Set the required options:
Menu Entry Meaning
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
  1. When you have set the required options, choose Continue

BRSPACE displays the menu Additional options for import.

Menu Entry Meaning
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 notfrom 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.
  1. To start processing with the selected options, choose Continue.

Results

Check the results in the BRSPACE logs.

  • The summary log space<DBSID>.log displays the return code.
  • The detail log s<encoded timestamp>.tbidisplays 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.

Leave a comment