Moving Tables to Encrypted Tablespace. [message #594181] |
Sun, 25 August 2013 03:01 |
|
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.
|
|
|
|
|