Table of Contents

Search

  1. Preface
  2. Fast Clone Overview
  3. Configuring and Using the Fast Clone Server
  4. Creating Cloning Configuration Files in the Fast Clone Console
  5. Unloading Data from the Source Database
  6. Loading Data to a Target
  7. Remote Configuration Management
  8. Fast Clone Command Line Interface
  9. Troubleshooting
  10. Fast Clone Configuration File Parameters
  11. Glossary

User Guide

User Guide

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.

0 COMMENTS

We’d like to hear from you!