user_data is a nonencryptedtablespace containing tables with data.
You must encrypt ail data in this tablespace.
Which three methods can do this?
A.
Use Data Pump.
B.
Use ALTERTABLE. . .MOVE
C.
Use CREATE TABLE AS SELECT
D.
Use alter tablespace to encrypt the tablespace after enabling row movement on all its
E.
Use altertablespace to encrypt the tablespace.
A B C are correct http://www.oracle.com/technetwork/testcontent/o19tte-086996.html
Finally, note that you can only create encrypted tablespaces; you cannot modify existing tablespaces to encrypt them. So, when you need existing data in encrypted tablespaces, the best solution is to first create encrypted tablespaces and then move the objects from the unencrypted tablespaces to them.
A, B, C
Thanks Vonpire!
Thanks Vonpire!
ABC
ABC
Maybe BCE
A also can be a solution
A.
Use Data Pump. You would export table and then import with REMAP_TABLESPACE ?
So it can also be a right solution
B.
Use ALTERTABLE. . .MOVE – You can move table to already encrypted tablespace
C.
Use CREATE TABLE AS SELECT – You can create new table in already encrypted tablespace
and drop the old one
E.
Use altertablespace to encrypt the tablespace. – current tablespace will be encrypted after this
you cannot modify existing tablespaces to encrypt them.
OK, so ABC 🙂
ABC