It's all about the answers!

Ask a question

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


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


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.