| Parameter |
Meaning |
Default |
Example |
| -C
<number> |
Number
of rows to copy in a block (buffer). The minimum buffer size allowed is 50 rows. |
32000 |
-C
65000 |
| -R
<read thread count> |
The
maximum number of read threads
to be started. This is provided to limit the number of read threads,
beyond the limitations that DBFastTableCopy
may encounter due to memory constraints or the number of partitions
or row segments in the table. |
Read
and write threads combined cannot exceed 98 |
-R 5 |
| -W
<write thread count> |
The
maximum number of write threads
to create. The actual number of write threads created may be less due
to memory constraints. |
Read
and write threads combined cannot exceed 98 |
-W
5 |
| -l
<buffer size> |
The
maximum size, in bytes, of a LONG or LONG RAW data column in the source database; this sets
the buffer size for this specific column. |
5000 |
-l
50000 |
| -P
<read partitioning> |
The
partitioning algorithm for reading the source table, which depends on
the type of Oracle table. Valid values are: T
= Single-stream read, which turns off parallel reading. If this mode
is chosen, the number of read threads is forced to 1. Results in a simple
selection statement. P
= Select by partition. Can only read partitioned tables, and creates
a selection for each partition. If the number of read threads is not
limited, a read thread is created for each partition, up to the maximum
number of threads supported. R
= Select by ROWID (for
nonpartitioned tables). DBFastTableCopy
develops a list of ROWID
ranges based on Oracle database files on which the table resides, and
uses these ranges to select subsets of the table for parallel reads.
As with partitioned reads, DBFastTableCopy
creates as many read threads as there are ranges, unless limited by
the maximum number of threads allowed. |
-P
T = single stream (table) read |
-P
P |
| -p
<partition list> |
Specifies
which partitions are to be copied; useful to segregate a copy of inactive
partitions from copies of active partitions. Used with –P
P only. If used with any other –P value, this parameter is ignored. Do not
use spaces in the list. |
-P
P will copy all partitions |
-p
ORDR_1,ORDR_2 |
| -X |
Prevents
writing to the target database table, no load started. Useful only for
testing read performance. |
Normal
write |
-X |
| -d <username/ |
The
schema username and password for the target database only. This allows
the table to be owned by another schema on the target database. You
must have privileges to write data and set database parameters on the
target table being copied. |
None |
-d
scott/tiger |
| -t
<table> |
The
name of the table on the target database. This allows you to copy to
a different named table on the target. All characteristics of the table
must match exactly. The name must be specified in uppercase. |
None |
-t
ORDERS2 |
| -s
<schema> |
The
name of the schema that owns the table on the source database. The schema
name must be specified in uppercase. This same schema name will be used
for the destination if -c is not specified. |
None |
-s
SAPR3 |
| -c
<schema> |
The
name of the schema that owns the table on the target database. Only
specify this option if the schema name is different from the source.
The schema name must be specified in uppercase. |
None |
-c
NEWSAPR3 |
| -w
<filename> |
The
name of a file containing a where clause to apply to the select statement to determine the records
you wish to copy. The file is assumed to be in the home directory where
DBFastTableCopy is being run. You can prepend
a relative directory specification off of $HOME
if you wish. The where
clause should be listed in the file such as WHERE
NAME = ‘SMITH’.
Do not end the clause
with a semicolon. |
None |
-w
whclauses/D010S |
| -h
or –H |
Print
out help for DBFastTableCopy. |
None |
-H |
| -v
or –V |
Print
out the version of DBFastTableCopy. |
None |
-V |
| -k
<keyforlinux> |
This
argument is only used for Linux versions of DBFastTableCopy. Use this argument to specify the required
key for your platform. |
None |
-k
1947251340 |
| -N
<rowInterval> |
Specifies
the interval at which you want a status message of the number of rows
copied, that is, every N rows. The default is 1 million.
|
1,000,000 |
-N
2000000 |
| -Z
<level> |
Trace
level for debugging. There are four levels, numbered 0 through 3. Each
level incorporates those below it and adds more information. |
-Z
0 |
-Z
2 |