053 No. 482

482.user_data is a nonencrypted tablespace this contains a set of tables with DATA. You want to
Convert all existing data in the User_data tablespace and the new data into the encrypted format.
Which methods would you use the achieve this? (Choose all, apply.)
A. Use data Pump to transfer the existing data to a new encrypted tablespace.
B. Use ALTER tablE MOVE to transfer the existing data to a new encrypted tablespace.
C. Use CREATE TABLE as SELECT to transfer the existing data to a new encrypted tablespace.
D. Enable row Movement for each table to being encrypted and then use the ALTER tablespace to encrypt
The tablespace.
E. Encrypt the User_data tablespace using the ALTER tablespace statement so, all the DATA in
The tablespace is automatically encrypted.
Answer: ABC

The following is restrictions for encrypted tablespaces:

• You cannot encrypt a existing tablespace with anALTERTABLESPACEStatement. However, can use Data Pump or SQL statements such asCREATETABLEASSELECTOrALTERTABLEMOVETo move existing table data into an encrypted tablespace.

• encrypted tablespaces is subject to restrictions when transporting to another database. see  "Limitations on transportable tablespace use".

• When recovering a database with encrypted tablespaces (for example after a SHUTDOWN ABORT or a catastrophic error that brings Down the database instance. Must open the Oracle wallet after database mount and before database open, so the Recove RY process can decrypt data blocks and redo.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

053 No. 482