Re: Oracle TDE Question
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Thu, 25 Feb 2016 07:32:00 -0700
Message-ID: <56CF1060.4050501_at_gmail.com>
Yes. It is supported to have a mix of tablespaces within the same instance. Note that Indexes are not forced to be on the 'same type' of tablespace, so that could be cause for concern and additional administration diligence.
Date: Thu, 25 Feb 2016 07:32:00 -0700
Message-ID: <56CF1060.4050501_at_gmail.com>
Yes. It is supported to have a mix of tablespaces within the same instance. Note that Indexes are not forced to be on the 'same type' of tablespace, so that could be cause for concern and additional administration diligence.
Depending on the hardware, and depending on the encryption overhead it is very reasonable to consider putting non-sensitive data in unencrypted tablespaces. However, with modern hardware, possibly minimal and even negligible impact is possible. As usual - test for yourself, within your own environment.
/Hans
On 25/02/2016 6:54 AM, Chris Taylor wrote:
> I think I know the answer to this question, but want to confirm for
> completeness.
>
> When you use Oracle TDE (with the appropriate licenses of course), is
> it supported to have both non-encrypted tablespaces and encrypted
> tablespaces in the same database, correct?
>
> If it's not I'd be surprised but wanted to confirm.
>
> Thanks!
>
> Chris Taylor
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 25 2016 - 15:32:00 CET