Re: Questions about TDE

You have to open wallet before you can access an encrypted column.

Regards
Harshan

On Tue, Feb 24, 2009 at 2:32 PM, hrishy <hrishys_at_yahoo.co.uk> wrote:

> Hi Harshan/Alan
>
> Well if you are able to sucesfully write that kind of queries and it works
>
> a join b on a.encrypted_col = b.unencrypted_col
>
> then isnt the purpose of encryption defeated ?
>
> regards
> Hrishy
>
>
>
>
> --- On Tue, 24/2/09, harshan eppuram <harshan.eppuram_at_gmail.com> wrote:
>
> > From: harshan eppuram <harshan.eppuram_at_gmail.com>
> > Subject: Re: Questions about TDE
> > To: "Guillermo Alan Bort" <cicciuxdba_at_gmail.com>
> > Cc: fmhabash_at_gmail.com, "oracle list" <oracle-l_at_freelists.org>
> > Date: Tuesday, 24 February, 2009, 8:44 AM
> > 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
>
>
>
>

-- 
Harshan Eppurath
040-40214832
09392426435

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