dbimport utility

The dbimport command imports previously exported data into another database.


             V          |                           
>>-dbimport----+------+-+--| Input-File Location |-------------->
               +- -c--+                                  
               +- -D--+                                  
               +- -nv-+                                  
               +- -q--+                                  
               '- -X--'                                  

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

The dbimport utility supports options for creating a database, specifying a dbspace for that database, defining logging options, and optionally, specifying ANSI/ISO-compliance or NLS case-insensitivity (or both) as properties of the database.
   '- -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.