Also, we confirmed with Oracle that this ghost data issue is indeed a bug that they have patched and will be fixed in a forthcoming CPU On Wed, Jul 22, 2009 at 2:11 PM, Michael Wehrle <michaelw436@xxxxxxxxx>wrote: > All, for your information, we have recently figured out a way to clean up > this ghost data besides an export / import. We have found that if you do an > RMAN backup with the COMPRESSED option, once you perform a restore on the > datafile, it will then be clean. I have tested this on individual datafiles > with success. > > > On Mon, Jul 6, 2009 at 12:19 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx > > wrote: > >> Karl, thanks for the interesting pointer, but that doesn’t explain the >> scenario I saw and reproduced in both 8i and 10g where there was unexpected >> data inserted into the blocks of a brand new tablespace. >> >> >> >> Regards, >> >> Brandon >> >> >> >> *From:* Karl Arao [mailto:karlarao@xxxxxxxxx] >> >> >> >> You may want to check the TDE FAQ, which I think answers your question. >> >> >> http://www.oracle.com/technology/deploy/security/database-security-10g/transparent-data-encryption/tde_faq.html#A11072 >> >> >> >> >> ------------------------------ >> Privileged/Confidential Information may be contained in this message or >> attachments hereto. Please advise immediately if you or your employer do not >> consent to Internet email for messages of this kind. Opinions, conclusions >> and other information in this message that do not relate to the official >> business of this company shall be understood as neither given nor endorsed >> by it. >> > >