Re: Questions about TDE
- From: harshan eppuram <harshan.eppuram@xxxxxxxxx>
- To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- Date: Tue, 24 Feb 2009 14:14:00 +0530
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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx>
> > Sent: Monday, February 23, 2009 7:16 PM
> > To: oracle list <oracle-l@xxxxxxxxxxxxx>
> > 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
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
--
Harshan Eppurath
040-40214832
09392426435
Other related posts:
