Requirements moving database object from non-encrypted tablespaces to encrypted Tablespaces

Bruce Krueger (11●1) | asked Dec 17 '15, 7:13 a.m.

Currently we have rational running on Oracle 11.2.0.4 and need to implement encrypted. What is IBM's recommended best practices?

There are 2 ways to do this in oracle.

1. Export/Import from non-encrypted tablespaces to encrypted tablespaces

2. Generate DDL to

ALTER TABLE <<owner>>.<<table_name>> move <<encrypted_tablespace_name>>

This would make indexe UNUSABLE and would need to be rebuilt

Also require ALTER USER CCM default tablespace <<encrypted_tablespace_name>>

Be the first one to answer this question!