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 > > > -- //www.freelists.org/webpage/oracle-l