Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Moving tables to Encrypted tablespace.

User_OCZ1TAug 24 2013 — edited Aug 25 2013

Hi ,

   i am using 11.2.0.3.0 version of oracle. We are planning to move some ~40 tables/indexes to new encrypted tablespace as a part of  TDE(transparent data encryption). Currently three tables are having size ~30GB and one having ~800GB other have <2GB in size.  And tables/indexes are altogether placed in different tablespaces.

  

   So my question is ,whether i should create as many no of encrypted table spaces as it was before as unencrypted tablespace

                                          or

   I should create one encrypted  tablespace and move all the tables/indexes into that, and it will not affect performance? Need Suggestion.

This post has been answered by JohnWatson on Aug 25 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2013
Added on Aug 24 2013
2 comments
613 views