Importing Tables with BR*Tools

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:

                                                  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)

-p|-profile

Database user/password (user)

-u|-user

BRSPACE export run / dump file (export)

-f tbimport -x|-export

Confirmation mode (confirm)

-c|-confirm

Extended output (output)

-o|-output

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.

                                               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

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)

       4.      Select an export run.

BRSPACE displays the menu Main options for import.

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

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

Results

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.