Moving Tables to Encrypted Tablespace. [message #594181] |
Sun, 25 August 2013 03:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9c2c5464937c21cabe9c54339a090539?s=64&d=mm&r=g) |
VIP2013
Messages: 91 Registered: June 2013
|
Member |
|
|
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.
|
|
|
|
|