User Guide

10.0
- 11.0

Back Next

Source Tables, Columns, and SQL Queries

Use the following command line parameters to specify the source tables and columns from which to unload data and any SQL queries that you want to use for unload processing:

all_tables: Indicates whether to unload all tables in the schema that is identified by the
owner
parameter and specifies the unload method to use for these tables. Options are:
0
. Use the
conv_path_tables
parameter value to determine the tables to unload with the conventional path unload method, and use the
tables
parameter to determine the tables to unload with the direct path unload method. Specify at least one table in one of the parameters for the unload job to run.
1
. Let Fast Clone determine whether it can perform a direct path unload. If a direct path unload is not possible, Fast Clone performs a conventional path unload.
2
. Force Fast Clone to perform a direct path unload for all source tables in the schema that is identified by the
owner
parameter.
3
. Force Fast Clone to perform a conventional path unload for all source tables in the schema that is identified by the
owner
parameter.
Default value: 0
conv_path_tables: A space- or comma-separated list of source tables or table partitions from which to unload data with the conventional path unload.
sql_queries: A space- or comma-separated list of SQL queries that are processed with the conventional path unload method. The queries must be enclosed in quotation marks. Add a backslash before each quotation mark. For example:
sql_queries=\"SELECT * FROM TABLE1\",\"SELECT * FROM TABLE2\"
Fast Clone writes the results of these queries to the QUERY1.dat and QUERY2.dat files.
tables: A space- or comma-separated list of source tables or table partitions from which to unload data with the direct path unload method. For example:
tables=TABLE1,TABLE2

Rename Saved Search

Table of Contents

User Guide

User Guide

Source Tables, Columns, and SQL Queries

Source Tables, Columns, and SQL Queries