RE: TDE issues

Roby,

1) Yes
2) No
3) No
4) No but we have seen similar problems with other databases
5) Both databases are on the same machine, 10.2.0.3.0
6) Both on the same machine, Solaris 9

Thanks. 


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: Roby Sherman [mailto:rxsherm@xxxxxxxxxxxxx] 
Sent: Tuesday, May 22, 2007 5:22 PM
To: William Wagman
Cc: oracle-l
Subject: Re: TDE issues

Wow. That's an interesting one.

Some Q's:

1. Can I assume that you also tried the same queries, specifically  
from devx to t1@testx without the encryption being turned on for t1?  
(Just to rule out other possibilities).
2. Have you also tried the same query with TDE turned ON both tables?
3. Have you tried other forms of the queries just to narrow the  
problem down? E.g.:
                select a.c1 from t2 a, oracle.t1@testx b where a.c1 =
b.c1
                select a.c1 from t2 a, oracle.t1@testx b where a.c1 !=
b.c1
                select c1 from t2 where c1 not in (select distinct c1
from  
oracle.t1@testx)
                etc...?

4. Have you tried the same query against testx from a different DB  
other than devx?
5. What version of Oracle is devx? What version of Oracle is testx?
6. What OS/HW platform are both DB's?


--Roby

/=======================================================================
|  Roby Sherman  ( r x s h e r m @ i n t e r e a l m . c o m )
|  DBA, Architect, Computer Scientist, Pain in the keister
|-----------------------------------------------------------------------

-----------------------------------------------
|  http://www.robysherman.org
|=======================================================================
| A computer without a Microsoft operating system is like a dog  
without bricks tied to it's head
\=======================================================================




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

Other related posts: