Re: TDE issues

From: Roby Sherman <rxsherm_at_interealm.com>
Date: Tue, 22 May 2007 18:21:59 -0600
Message-Id: <0D75A225-8779-4E37-B784-1F2FDE197DC2@interealm.com>

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_at_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_at_testx b where a.c1 = b.c1 select a.c1 from t2 a, oracle.t1_at_testx b where a.c1 != b.c1 select c1 from t2 where c1 not in (select distinct c1 from oracle.t1_at_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

Received on Tue May 22 2007 - 19:21:59 CDT