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.