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 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, perform one of the following steps:
  • 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 file when you save the configuration file. The Fast Clone Console then reads the master key IDs and values and writes them to the [MKEY_ID] and [MKEY_VALUES] sections.
  • If you use the conventional path unload method, ensure that the Oracle wallet is open in the database before you start the unload job. Use the following command:
    ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "
    password
    ";

0 COMMENTS

We’d like to hear from you!