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

Unloading Data from TDE-Encrypted Columns and Tablespaces

Unloading Data from TDE-Encrypted Columns and Tablespaces

Fast Clone supports Oracle sources that use Oracle Transparent Data Encryption (TDE) encryption of columns and tablespaces.
Fast Clone supports encrypted columns for Oracle 10.2.0.0 and later and encrypted tablespaces for Oracle 11.2.0.2 and later.
Fast Clone supports TDE with all Oracle encryption algorithms, including 3DES and AES with 128-bit, 192-bit, and 256-bit key lengths. Fast Clone also supports TDE with HMAC integrity checking and SALT enhanced security.
To unload data from encrypted columns or tablespaces, you must open the Oracle encryption wallet in one of the following ways:
  • If you use the direct path unload method, Fast Clone uses the master key IDs and values in the [MKEY_ID] and [MKEY_VALUES] sections of the cloning configuration file to unload data from encrypted tables. The Fast Clone Console prompts you to open the Oracle wallet when you save the configuration file.
  • If you use the conventional path unload method, you must open the wallet before you start the unload job to grant access to the encrypted columns or tablespaces. Use one of the following commands, depending on your Oracle version, to open the wallet in Oracle:
    -- Oracle 10g version ALTER SYSTEM SET ENCRYPTION WALLET OPEN AUTHENTICATED BY "
    password
    "; -- Oracle 11g version ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "
    password
    ";

0 COMMENTS

We’d like to hear from you!