 | » |
|
|
|
|
|
DBFastTableCopy is a standalone utility program
that copies the data content of a single database table from a
source database to a target database using Oracle's Net8, Oracle
Call Interface (OCI), and Direct Path Technologies. The DBFastTableCopy
utility provides functionality to:
- Minimize the time to copy the data
- Minimize down time on the source database
- Minimize the number of captured-in-flight transactions that
must be applied to the target database to synchronize the source
and target databases
- Run in multi-threaded mode if table characteristics allows
it (for example, partitioned)
For more information on the features of DBFastTableCopy,
refer to the DBFastTableCopy User Guide. To obtain
a DBFastTableCopy kit, contact your HP representative.
|
The DBFastTableCopy utility is supported and is available as a
licensed tar file
for the the following hardware and software platforms:
- HP-UX 11i v2 or higher running Oracle 9i or higher
on Integrity systems
- HP-UX 11i v1 or higher running Oracle 9i or higher on PA-RISC systems
- Tru64 UNIX V5.1 or higher running Oracle 9i or higher on Alpha systems
- SUSE Linux Enterprise Server v10.0 or higher running Oracle 9i or higher on x86_64 systems
- Red Hat Enterprise Linux AS release 3.0 or higher running Oracle 9i or higher on Integrity systems
The kit contains executables for both Oracle 9i as well
as an Oracle 10g environment.
DBFastTableCopy uses Net8 to connect to the Oracle database server instances, as shown in the following figure. Currently, the utility supports copying tables from Oracle 8i or higher databases.
See the DBFastTableCopy User Guide for complete installation instructions.
The DBFastTableCopy utility is invoked from the command
line using command-line parameters and uses of a combination of mandatory
as well as optional parameters.
The mandatory parameters consist
of:
- Source database path (Oracle destination database Net8 listener)
- Target database path (Oracle source database Net8 listener)
- Output mode
- Name of the Oracle database table to copy
- Schema username and password
You can also specify various optional
parameters.
To run DBFastTableCopy, enter the TblCopy
command using the following syntax:
TblCopy -S <path> -D <path> -O <mode> -T <table> -u <username/password>
You can also run DBFastTableCopy in Information Only mode, which reads
and processes the table schema of the database and, using information
available from the source database, determines if the database can be
copied, as well as the approximate amount of data that would be copied.
The example included
here shows an example of the output from Information Only mode.
DBFastTableCopy has extensive trace and debug logging
capabilities. You can generate a very detailed trace of program steps,
buffer contents, and potential errors. Currently, four trace levels are available. Each trace
level includes all the trace elements of the lower-order levels.
- Trace Level 0
Tracing is turned off (trace parameter -Z
is not used). This option gives you the best performance while DBFastTableCopy
is copying the data. Some basic startup and shutdown information is
still recorded.
- Trace Level 1
Tracing is turned on. The output includes all the information from Trace
Level 0 in addition to some OCI and thread information.
- Trace Level 2
Tracing is turned on. The output includes all the information from Trace
Level 1 in addition to displaying the select statements generated and
the buffer usage for both read and write threads.
- Trace Level 3
Tracing is turned on. The output includes all the information from Trace
Level 2 in addition to displaying the actual contents of data rows in
the buffers. This trace level provides the most detailed information.
» Back to tutorial home
|
