Re: Questions about TDE

From: harshan eppuram <harshan.eppuram_at_gmail.com>
Date: Tue, 24 Feb 2009 14:14:00 +0530
Message-ID: <88b2bacc0902240044j5017bf81r653715523ebe57a4_at_mail.gmail.com>

I checked. This will work on Oracle 11g. That is you can join an encrypted column with a non encrypted column on 11g. But our client is on 10gr2.

On 2/24/09, Guillermo Alan Bort <cicciuxdba_at_gmail.com> wrote:
>
> you mean like
>
> from a join b on a.encrypted_col = b.unencrypted_col?
>
> That wouldn't make sense and it's not supposed to work.
>
> Other than that, I'd really go with 11g tablespace level encryption
> since it's way faster and a lot more reliable than TDE.
>
>
> hth
>
> Alan Bort
> Oracle Certified Professional
>
>
>
> On Mon, Feb 23, 2009 at 11:26 PM, FMHabash <fmhabash_at_gmail.com> wrote:
> > We ran into issues with 10g TDE regarding its restrictions. We had to
> upgrade to 11g to use tablespace encryption which is working much better in
> terms of performance and stability. We are conducting performance testing
> currently.
> >
> >
> > -----Original Message-----
> > From: harshan eppuram <harshan.eppuram_at_gmail.com>
> > Sent: Monday, February 23, 2009 7:16 PM
> > To: oracle list <oracle-l_at_freelists.org>
> > Subject: Questions about TDE
> >
> > Hi All,
> >
> > We are implementing TDE(Transidential Data Encryption) on a solaris box
> > 10gr2 RAC ASM for one of client which is a Bank. We are facing following
> two
> > issues. This is a 4 TDB database.
> >
> > 1. Joining between encrypted and no encrypted table's columns are not
> > working.
> > 2. Encryption process is taking too much of time say 5 days ( We first
> > created tables with out encryption loaded data and then modified the
> columns
> > to be encrpted)
> >
> > Let me know if anybody come accross such sitiuation.
> >
> > Thanks and Regards
> > Harshan
> >
> >
> > --
> > Harshan Eppurath
> > 040-40214832
> > 09392426435
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>

-- 
Harshan Eppurath
040-40214832
09392426435

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 24 2009 - 02:44:00 CST