User Guide

10.0
- 11.0

Back Next

Product Overview

Fast Clone is a high-performance data cloning tool for unloading Oracle data and moving that data quickly and efficiently to other databases and warehouse appliances in a heterogeneous environment.

You can use Fast Clone in many scenarios. For example, use it to migrate data from test to production systems, clone data to another type of system or database, materialize targets for change data replication, or create a copy of your data for development or backup purposes.

Fast Clone runs on most Linux, UNIX, and Windows operating systems. It can move data from an Oracle source system to a broad range of target relational database systems and warehouse appliances on different types of Linux, UNIX, and Windows operating systems. You can also move data from an Oracle source system to a Hadoop Distributed File System (HDFS).

Fast Clone provides the following unload methods:

Direct path unload. Reads data directly from Oracle data files, without using the Oracle Call Interface (OCI). This method is much faster than the conventional path unload method. However, you cannot use the direct path unload method to run unload jobs from a system that is remote from the Oracle source, perform SQL JOIN operations on two or more tables, or unload data from views or cluster tables.

Conventional path unload. Uses the OCI to retrieve metadata and data from the Oracle source. This method is slower than the direct path unload method, but it does not have the limitations of the direct path unload method.

You can configure Fast Clone to unload data in ASCII, EBCDIC, COMP-3, or Teradata binary format. Fast Clone prepares the data for input to the native load utility of the target database.

Optionally, for Greenplum, Netezza, Teradata, and Vertica targets, Fast Clone provides the DataStreamer add-on component for even better performance. DataStreamer sends the unloaded data directly to Teradata Parallel Transporter (TPT), Greenplum Gpfdist, Netezza external tables, or Vertica targets. As a result, DataStreamer transfers data faster and reduces I/O and storage requirements.

Fast Clone includes the following additional features:

Filters the Oracle tables and table partitions to be unloaded.

Lets you define SQL queries, such as table joins for unloading data.

Generates scripts for creating the target tables and for loading data.

Provides a built-in compression feature that can quickly compress data during unload processing.

Supports Oracle Automatic Storage Management (ASM), Oracle Cluster File Systems (OCFS), chained rows, fixed-length rows, and most datatypes including LOB datatypes.

Supports different output formats including fixed length record format, EBCDIC, COMP-3, and Teradata binary format.

Provides reporting and monitoring capabilities and can send alerts, such as SNMP traps.

Provides integration with the Informatica Data Replication product to prepare targets for change data replication.

Rename Saved Search

Table of Contents

User Guide

User Guide

Product Overview

Product Overview