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.
Encrypting an existing tablespace:
SQL> alter tablespace users
2 encryption using ‘AES256’
3 default storage (encrypt);
encryption using ‘AES256’
*
ERROR at line 2:
ORA-02142: missing or invalid ALTER TABLESPACE option
An existing tablespace cannot be encrypted. If you need your existing data to be encrypted, create a new encrypted tablespace and move your data to it by using:
ALTER TABLE table_name MOVE encrypted_tablespace_name;
OR
CREATE TABLE table_in_encrypted_form
TABLESPACE encrypted_tablespace_name
AS
SELECT * FROM table_in_clear_text_form;
OR any others means you have, to move data from one tablespace to the other.
Why would you use Data Pump to move data from one TS to another?