It's all about the answers!

Ask a question

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


Bruce Krueger (11) | 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
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>>



Be the first one to answer this question!


Register or to post your answer.