Home » RDBMS Server » Performance Tuning » Moving Tables to Encrypted Tablespace. (11.2.0.3.0 version of oracle.)
Moving Tables to Encrypted Tablespace. [message #594181] Sun, 25 August 2013 03:01 Go to next message
VIP2013
Messages: 84
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.
Re: Moving Tables to Encrypted Tablespace. [message #594182 is a reply to message #594181] Sun, 25 August 2013 04:27 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
it will not affect performance?


It will not, any option you will take.

Regards
Michel
Re: Moving Tables to Encrypted Tablespace. [message #594272 is a reply to message #594182] Tue, 27 August 2013 03:20 Go to previous message
VIP2013
Messages: 84
Registered: June 2013
Member
Thanks michel. Appreciate your prompt response.
Previous Topic: dynamic sql choosing wrong index
Next Topic: Please guide to improve the performance of query
Goto Forum:
  


Current Time: Sat Aug 23 15:25:29 CDT 2014

Total time taken to generate the page: 0.59188 seconds