dbimport utility
The dbimport command imports previously exported data into another database.
Syntax
.----------.
V |
>>-dbimport----+------+-+--| Input-File Location |-------------->
+- -c--+
+- -D--+
+- -nv-+
+- -q--+
'- -X--'
(2)
>--| Create Options |------+-----------+--database-------------><
+- -V-------+
'- -version-'
Element | Purpose |
---|---|
-c | Completes importing data even when certain nonfatal errors occur. |
-D | Specifies a default extent size of 16 KB for the first and subsequent extents during the import operation, if the extent sizes are not specified in the CREATE TABLE statement. |
-nv | While the dbimport -nv command is running, tables with foreign-key constraints that ALTER TABLE ADD CONSTRAINT creates in enabled or filtering mode are not checked for violations, as if NOVALIDATE has been specified. |
-q | Suppresses the display of error messages, warnings, and generated SQL data-definition statements. |
-V | Displays the software version number and the serial number. |
-version | Extends the -V option to display additional information about the build operating system, build number, and build date. |
-X | Recognizes HEX binary data in character fields. |
database | Declares the name of the database to create. |
dbimport input-file location options
The input-file location specifies the location of the database.exp directory, which contains the files that the dbimport utility imports.
|-+-----------------------------------------------------------------+--|
+- -i--directory--------------------------------------------------+
'- -t--device--+-------------------------------+--+-------------+-'
'- -b--blocksize-- -s--tapesize-' '- -f--pathname-'
Element | Purpose |
---|---|
-b blocksize |
Specifies, in kilobytes, the block size of the tape device. If you are importing from tape, you must use the same block size that you used to export the database. If you do not use the -b option, the default block size is 1. |
-f pathname | Specifies where dbimport can find the schema file to use as input to create the database when the data files are read from the tape. |
-i directory | Specifies the complete path name on disk of the database.exp directory, which holds the input data files and schema file that dbimport uses to create and load the new database. The directory name must be same as the database name. |
-s tapesize | Specifies, in kilobytes, the amount of data that you can store on the tape. |
-t device | Specifies the path name of the tape device that holds the input files. |
dbimport create options
|--+--------------+--+-----------------------+--+------+--------|
'- -d--dbspace-' '- -l--+-+----------+-+-' '- -ci-'
| '-buffered-' |
'- -ansi-------'
Element | Purpose |
---|---|
-ansi | Creates an ANSI/ISO-compliant database in which the ANSI/ISO rules for transaction logging are enabled. Otherwise, the database uses explicit transactions by default. |
-ci | Specifies the NLS case-insensitive property. Otherwise, the database is case-sensitive by default. |
-d dbspace | Specifies the dbspace where the database is created.. |
-l | Establishes unbuffered transaction logging for the imported database. If the -l flag is omitted, the database is unlogged. |
-l buffered | Establishes the buffered transaction logging for the imported database. If -l is included but buffered is omitted, the database uses unbuffered logging. |