dbexport utility

The dbexport command unloads a database into text files that you can later import into another database. The command also creates a schema file.

>>-dbexport----------------------------------------------------->

     .---------------------------------------------------.               
     V                                                   |               
>--+---+-----------------------------------------------+-+--database-+-><
   |   +- -c    ---------------------------------------+             |   
   |   +- -d-------------------------------------------+             |   
   |   +- -no-data-tables--tablenames------------------+             |   
   |   +- -no-data-tables-accessmethods--accessmethods-+             |   
   |   +- -nw------------------------------------------+             |   
   |   +- -q-------------------------------------------+             |   
   |   |                                               |             |   
   |   +-| Destination Options |-----------------------+             |   
   |   +- -ss------------------------------------------+             |   
   |   +- -si------------------------------------------+             |   
   |   '- -X-------------------------------------------'             |   
   '-+-----------+---------------------------------------------------'   
     +- -V-------+                                                       
     '- -version-'                                                       

Element	Purpose
-c	Makes dbexport complete exporting unless a fatal error occurs.
-d	Makes dbexport export simple-large-object descriptors only, not simple-large-object data.
-q	Suppresses the display of error messages, warnings, and generated SQL data-definition statements.
-ss	Generates database server-specific information for all tables in the specified database. This option specifies initial and next-extent sizes, fragmentation information if the table is fragmented, the locking mode, the dbspace for a table, the blobspace for any simple large objects, and the dbspace for any smart large objects.
-si	Excludes the generation of index storage clauses for non-fragmented tables. Note: The -si option is available only with the -ss option.
-X	Recognizes HEX binary data in character fields.
-no-data-tables	Prevents data from being exported for the specified tables. Only the definitions of the specified tables are exported. Accepts a comma-separated list of names of tables for which data will not be exported.
-no-data-tables-accessmethods	Prevents data from being unloaded using the specified access methods. Accepts a comma-separated list of names of access methods. Tables using those access methods are not unloaded.
-nw	Generates the SQL for creating a database without the specification of an owner.
-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.
database	Specifies the name of the database that you want to export.

|--+---------------------------------------------------------------+--|
   +- -o--directory------------------------------------------------+   
   '- -t--device-- -b--blocksize-- -s--tapesize--+---------------+-'   
                                                 '- -f--pathname-'     

Element	Purpose
-b blocksize	Specifies, in kilobytes, the block size of the tape device.
-f pathname	Specifies the name of the path where you want the schema file to be stored, if you are storing the data files on tape.
-o directory	Specifies the directory on the disk in which dbexport creates the database.exp directory. This directory holds the data files and the schema file that dbexport creates for the database.
-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 where you want the text files and, possibly, the schema file stored.