Re: TDE issues
- From: Roby Sherman <rxsherm@xxxxxxxxxxxxx>
- To: wjwagman@xxxxxxxxxxx
- Date: Tue, 22 May 2007 18:21:59 -0600
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
\=======================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
