053第482

482.USER_DATA is a nonencrypted tablespace that 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 to achieve this? (Choose all that 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 be encrypted and then use ALTER TABLESPACE to encrypt
the tablespace.
E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in
the tablespace is automatically encrypted.
Answer: ABC

The following are restrictions for encrypted tablespaces:

• You cannot encrypt an existing tablespace with an ALTER TABLESPACE statement. However, you can use Data Pump or SQL statements such as CREATETABLE AS SELECT or ALTER TABLE MOVE to move existing table data into an encrypted tablespace.

• Encrypted tablespaces are 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), you must open the Oracle wallet after database mount and before database open, so the recovery process can decrypt data blocks and redo.