Procedure documentationImporting Tables with BR*Tools

 

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

Note Note

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

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

End of the note.

Note Note

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

Do not use this procedure for restore.

End of the note.

Procedure

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

    • BRGUI or BRTOOLS:

      1. Choose Start of the navigation path Segment Management Next navigation step Import tables End of the navigation path.

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

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

        Import type (type)

        -f tbimport -y|-type

        Table owner (owner)

        -f tbimport -o|-owner

        Table names (tables)

        -f tbimport -t|-tables

        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.

      3. Choose Continue.

        BRGUI or BRTOOLS prompts you to start BRSPACE.

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

      Note Note

      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.

      End of the note.

    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)

    Util.

    Export utility used: EXP or EXPDP

  4. Select an export run.

    BRSPACE displays the menu Main options for import.

  5. Set the required options:

    Menu Entry

    Meaning

    Import utility (utility)

    – display only

    -f tbimport -l|-utility

    Import type (type)

    -f tbimport -t|-type

    Owners for import (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

    Import table triggers (triggers)

    -f tbimport -e|-triggers (only for IMPDP)

  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 (only for IMP)

    Commit after each array insert (commit)

    -f tbimport -m|-commit (only for IMP)

    Ignore creation errors (ignore)

    -f tbimport -n|-ignore (only for IMP)

    Table exists (action)

    -f tbimport -a|-action (only for IMPDP)

    Parallel degree (parallel)

    -f tbimport -p|-parallel (only for IMPDP)

    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 (only for IMP)

    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.

Result

Check the results in the BRSPACE logs.

For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs 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.