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.
Start the procedure using BRGUI or BRTOOLS, or from the command line:
BRGUI or BRTOOLS:
Choose
.BRGUI or BRTOOLS displays the menu BRSPACE options for import tables, where you specify the options with which you call BRSPACE.
Set the required options:
Menu Entry |
Equivalent BRSPACE Command Option |
---|---|
BRSPACE profile (profile) |
|
Database user/password (user) |
|
BRSPACE export run / dump file (export) |
|
Import type (type) |
|
Table owner (owner) |
|
Table names (tables) |
|
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. |
Choose Continue.
BRGUI or BRTOOLS prompts you to start BRSPACE.
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.
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.
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 |
Select an export run.
BRSPACE displays the menu Main options for import.
Set the required options:
Menu Entry |
Meaning |
---|---|
Import utility (utility) - display only |
|
Import type (type) |
|
Owners for import (owner) |
|
Tables for import (tables) |
|
Import table rows (rows) |
|
Import table indexes (indexes) |
|
Import table constraints (constraints) |
|
Import table grants (grants) |
|
Import table triggers (triggers) |
-f tbimport -e|-triggers (only for IMPDP) |
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) |
|
IMP command |
The IMP command that is to be executed using the current settings. For more information, see your Oracle documentation. |
To start processing with the selected options, choose Continue.
Check the results in the BRSPACE logs.
The summary log space<DBSID>.log displays the return code.
The detail log s<encoded timestamp>.tbi displays the details.
The structure change log struc<DBSID>.log logs all structure changes.
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.