RE: TDE issues

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Wed, 23 May 2007 16:02:18 -0700
Message-ID: <FE043305B38A0F448F3924429D650C2A02B649BE@VEXBE2.ex.ad3.ucdavis.edu>

Roby,

Yes
No
No
No but we have seen similar problems with other databases
Both databases are on the same machine, 10.2.0.3.0
Both on the same machine, Solaris 9

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
-----Original Message-----
From: Roby Sherman [mailto:rxsherm_at_interealm.com] 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:

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).
Have you also tried the same query with TDE turned ON both tables?
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...?
Have you tried the same query against testx from a different DB other than devx?
What version of Oracle is devx? What version of Oracle is testx?
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 Wed May 23 2007 - 18:02:18 CDT