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 "