Requirements moving database object from non-encrypted tablespaces to encrypted Tablespaces
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
OR
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>>