Unloading Data to Files of Fixed-Length Record Format
Unloading Data to Files of Fixed-Length Record Format
Fast Clone can unload data to output files that use fixed-length record format. To use output files of fixed-length record format, you must enable padding for the fields.
In data files of fixed-length record format, each field has the same start position and end position in every record. Fast Clone records these positions for all of the columns in the output control files. If the number of bytes of data in a field is less than the field length, Fast Clone can pad the field on the right with space characters. Use this format to unload data to files that use blank column and row separators.
To enable padding for all columns in fixed-length record format data files, use one of the following methods:
In the Fast Clone Console, on the
Runtime Settings
>
Format Settings
view, select the
Pad with Blanks (fixed length)
option.
Edit the configuration file to set the
right_pad_columns
parameter to true.
From the command line, set the
RIGHT_PAD_COLUMNS
parameter to true.
If you unload data to a fixed-length format file and configured Fast Clone to unload data from columns that have BLOB, CLOB, NCLOB, LONG, and LONG RAW datatypes to a separate file, Fast Clone unloads all of the column data. Otherwise, the maximum amount of data that Fast Clone unloads to a fixed-length format file is 8 KB.