User Guide

11.0
- 10.0

Back Next

Source Column Parameters

In the [COLUMN_BIT_MASK], [SOURCE_INDIRECT_TABLES_COLUMNS_LIST], and [BIN_COLUMN_BIT_MASK] sections of the configuration file, list the source columns from which to unload data.

The [COLUMN_BIT_MASK] section uses the following parameter to list column bit masks for the tables that are specified in the [SOURCE_TABLES] section and unloaded with the direct path unload method:

table_id_column_bit_mask: A hexadecimal bit mask that is used to select the columns for unload processing. The least significant bit indicates the first column. The most significant bit indicates the last column. Set a column bit in the bit mask to 1 to unload data from the column. Set a column bit in the bit mask to 0 to not process the column.
For example, a table that is identified by the
table1
key in the [SOURCE_TABLES] section contains the following columns: COL1, COL2, COL3, COL4. To unload data from only COL4, set the binary bit mask for the table to 1000. The hexadecimal value of binary 1000 is 0x8:
table1_column_bit_mask=0x8
If a table does not have a bit mask, Fast Clone unloads data from all columns.; If you set the
column_list_clause_byname_filtering
parameter to true in the [RUN] section of the configuration file, you must replace the bit mask values that the Fast Clone Console generates with comma-separated lists of column names in any order. For example:
table1_column_bit_mask=COL2,COL1,COL4
Fast Clone does not provide command line parameters to specify column bit masks. You can specify column bit masks only in a configuration file.

The [SOURCE_INDIRECT_TABLES_COLUMNS_LIST] section uses the following parameter to list columns for the tables that are specified in the [SOURCE_INDIRECT_TABLES] section and unloaded with the conventional path method:

table_id_column_list: A comma-separated list of column names that identify the columns in a table from which to unload data. For example:
table1_column_list=COL2,COL1,COL4
Optionally, you can use SQL expressions to specify custom column formats.
To specify a custom date or timestamp format, use the following statement syntax:
to_char(COLUMN_NAME, 'custom_format') as COLUMN_NAME
This custom format overrides the
date_format
or
timestamp_format
parameter value. For information about Oracle datetime format, see the Oracle documentation.
To specify a value to replace null values, use the following statement syntax:
nvl(COLUMN_NAME, 'null_replacement_value') as COLUMN_NAME
To specify a custom precision value for a NUMBER column, use the following statement syntax:
round(NUMBER_COLUMN_NAME, custom_precision) as NUMBER_COLUMN_NAME
To specify a custom column size to pad column values on the right with blank spaces when the length of the column value is less than the custom column size, use the following statement syntax:
rpad(COLUMN_NAME, column_size, ' ') as COLUMN_NAME
For example, to use the custom date format dd/mm/yyyy for the COL4 column and replace null values in COL4 data with 14/12/2017, use the following table_id_column_list statement:
table1_column_list=COL2,COL1,nvl(to_char(COL4, 'dd/mm/yyyy'), '14/12/2017') as COL4

The [BIN_COLUMN_BIT_MASK] section uses the following parameter to list column bit masks for the columns that are unloaded in binary format:

table_id_bin_column_bit_mask: A hexadecimal bit mask that is used to select the columns to unload in binary format. The least significant bit indicates the first column. The most significant bit indicates the last column. Set a column bit in the bit mask to 1 to unload data from the column in binary format. For example:
table1_bin_column_bit_mask=0x8

Rename Saved Search

Table of Contents

User Guide

User Guide

Source Column Parameters

Source Column Parameters