This BRSPACE function imports tables from an operating system file. For more information, see Importing Tables with BR*Tools and Special Export and Import Functions with BRSPACE.
BRSPACE now supports the Oracle Data Pump tool for import, which is called “impdp” in this section. The conventional import is called “imp”.
Note
Since this function directly uses the Oracle import tool IMP, see the Oracle documentation for more information on most of the parameters listed below.
Function options:
-a|-action: specifies the processing action for existing tables with impdp
Syntax: -a|-action skip|append|truncate|replace
skip leaves the table as it is and moves on to the next object.
append loads rows from the source and leaves existing rows unchanged.
truncate deletes existing rows and then loads rows from the source.
replace drops the existing table and then creates and loads it from the source.
This is only supported for impdp.
Default: skip
-b|-buffer: specifies the import buffer size for imp
Syntax: -b|-buffer <size>
<size> specifies the size in KB
Default: 10240
-c|-constraints: specifies whether table constraints are imported
Syntax: -c|-constraints yes|no
Default: yes
-e|-triggers: specifies whether triggers are imported with impdp
Syntax: -e|-triggers yes|no
Default: yes
-f|-force: forces import, even if SAP users are connected
Default: import is not forced if SAP user is connected
-g|-grants: specifies whether table grants are imported
Syntax: -g|-grants yes|no
Default: yes
-i|-indexes: specifies whether table indexes are created
Syntax: -i|-indexes yes|no
Default: yes
-m|-commit: specifies whether there is a commit after each array insert with imp
Syntax: -m|-commit yes|no
Default: yes
-n|-ignore: specifies whether table creation errors are ignored with imp
Syntax: -n|-ignore yes|no
Default: no
-o|-owner: defines the SAP owner of the tables to be imported - useful in Multiple Components in One Database (MCOD) configurations
Syntax: -o|-owner <owner>|<owner_list>
<owner> or <owner_list> specifies the name of the SAP owner or owners
Default: no default in MCOD, otherwise the single SAP owner
-p|-parallel: specifies the degree of parallelism for the import with impdp
Syntax: -p|-parallel <degree>
Default: 1
-r|-rows: specifies whether table rows are imported
Syntax: -r|-rows yes|no|only
only specifies that only data is imported for impdp
Default: yes
-t|-tables: specifies the table(s) to be imported
Syntax: -t|-tables [<owner>.]<table|<table_list>
Default: none
-x|-export: specifies the export file
Syntax: -x|-export <exp_run>|<exp_dump>|<exp_dump_list>
<exp_run> specifies the BRSPACE run identifier where the export dump file was created, that is, the BRSPACE log name (s<coded_timestamp>.tbr)
<exp_dump> specifies the full path of the export dump file (not necessarily a BRSPACE export)
<exp_dump_list> specifies a list of export dump files (not necessarily BRSPACE export dump files)
Default: last BRSPACE export run
-y|-type specifies the type of import
Syntax: -y|-type full|tables|indexfile|show|sqlfile
full imports everything
tables imports individual tables as specified in the -t|-table parameter (see above)
indexfile dummy import – the DDL statements are written to the text file indfile.sql in the working directory but there is no import. Only supported for imp.
show shows the DDL statements in the export dump file but there is no import. Only supported for imp.
sqlfile means that DDL statements from the objects in the export dump file are stored in the text file sqlfile.sql in the working directory. No data is imported. Only supported for impdp.
Default: full
-z|-filesize specifies the dump file size for imp
Syntax: -z|-filesize <size>
<size> specifies the maximal dump file size in MB
Default: value from BRSPACE export