Table of Contents

Search

  1. Preface
  2. Fast Clone Overview
  3. Configuring and Using the Fast Clone Server
  4. Creating Cloning Configuration Files in the Fast Clone Console
  5. Unloading Data from the Source Database
  6. Loading Data to a Target
  7. Remote Configuration Management
  8. Fast Clone Command Line Interface
  9. Troubleshooting
  10. Fast Clone Configuration File Parameters
  11. Glossary

User Guide

User Guide

Unload Overview

Unload Overview

Fast Clone can unload data from regular tables, compressed tables, partitioned tables, views, materialized views, index-organized tables, and encrypted tables and tablespaces. For all target types, you can configure Fast Clone to unload data into output files or pipes.
For Greenplum, Netezza, and Teradata targets, if you use the direct path unload method and the DataStreamer add-on component, you can configure Fast Clone to stream data to the target database. Streaming data avoids the use of intermediate storage for output data files.
Fast Clone provides two methods of unloading data from an Oracle source: direct path unload and conventional path unload. The direct path unload method is much faster because it reads Oracle data files directly. It also works with the DataStreamer component. The conventional path unload method uses the standard Oracle Call Level Interface (OCI) to read data and metadata. With the conventional path method, you can unload data over the network. Also, Fast Clone can read data from additional types of Oracle objects, such as views and cluster tables.
You can run a data unload job from the Fast Clone Console or command line. If you use the Fast Clone Console, the Console runs the unload script that is specified in the runtime settings to start the Fast Clone executable. By default, the unload script name is unload.cmd on Windows and unload.sh on Linux and UNIX. The Fast Clone executable uses the cloning configuration file to unload data. If you use the command line, you can start the Fast Clone executable directly from the command line or run the unload script. When you enter the Fast Clone executable or unload script at the command line, you can specify the unload parameters either by using the
config
parameter to point to the cloning configuration file or by entering the parameters at the command line.

0 COMMENTS

We’d like to hear from you!