Download Backup Restore User's Guide

Dmsql Command
[LOB_FORMAT= INTERNAL | EXTERNAL]
This specifies that when exporting columns of
large object types (such as blob, clob, nclob, nblob and other files) external files will be generated.
For each column of large object type in each row, an external file will be generated. If this option is
not specified, the content of data will be embedded in a data file.
blobtempdir<m>\blbtmpf<n>.<tmp | txt>。When naming external files it’s important to keep the
following in mind: blobtempdir<m>\blbtmpf<n>.<tmp | txt>.
m specifies the minimum un-used number counted from 1 in the directory.
For example, if there are already directories named blobtempdir1, blobtempdir2 and blobtempdir3,
the newly created directory for containing external files will be blobtempdir4.
n specifies the minimum un-used number counted from 1 in the directory.
Whether the file extension name is tmp or txt depends on whether the exported column is BLOB
type, FILE type or CLOB type. If the column type is BLOB or FILE, the file extension name will be
tmp. Otherwise, the column type is txt.
server_column_name This lists the names of the source table columns that are going to be
exported from the database. If there are spaces in table name, use double quotes to enclose the
column names.
column_position Specifies the column byte position in data file.
server_columnnameand column_position are separated by space character(s). column_position is
specified by two numbers that are separated by (:).For example a 1:40 means the data loader
should look for data from 1st byte to 40th byte in data file. We will use space characters to align the
data field vertically. If the data in the source table exceeds the field length, the data output will be
truncated.
FORMAT=FIXED
[LOB_FORMAT=INTERNAL | EXTERNAL]
<server_column_name> <column_position>
TABLE
EXPORT
INTO data_file
table_name
owner_name
LOG log_file
DESCRIPTION description_name
STOP_ON_ERROR
Figure 7-1 EXPORT syntax
©Copyright 1995-2012 CASEMaker Inc.
8-3