User Guide

11.0
- 10.0

Back Next

WHERE Condition Parameter

In the [WHERE_CONDITION] and [SOURCE_INDIRECT_TABLES_WHERE_CONDITION] sections of the configuration file, optionally specify WHERE conditions for the source tables.

The [WHERE_CONDITION] section defines WHERE conditions for the tables that are unloaded with the direct path unload method. The [SOURCE_INDIRECT_TABLES_WHERE_CONDITION] section defines WHERE conditions for the tables that are unloaded with the conventional path unload method.

In both sections, use the following parameter to define the WHERE condition:

table_id_where_condition: Specifies a WHERE clause that is used to filter the row data to be unloaded from the table that is defined by the
table_id
key in the [SOURCE_TABLES] or [SOURCE_INDIRECT_TABLES] section of the cloning configuration file. For tables that do not have WHERE clause, Fast Clone unloads all rows. For more information about SQL operators for WHERE clauses, see the SQL documentation.
For example, the following statement specifies a WHERE clause for a DATE column:
table1_where_condition=( DATE_COLUMN >= to_date('12.14.2012 10:22:14', 'mm.dd.yyyy hh24:mi:ss') )
You can specify only one WHERE clause for a
table_id
table.

Rename Saved Search

Table of Contents

User Guide

User Guide

WHERE Condition Parameter

WHERE Condition Parameter