I'm installaing InfoSphere CDC Oracle Redo 6.5 on AIX 6.1, source and target databases are the same version 11gR2. the source database contains some tables with encrypted columns (Oracle uses a wallet to encrypt those columns). In an empty Schema on the target database we do an initial refresh, this operation ends with no errors, but when the status of the mapping on the management console passe to 'active' (capture of data changes begin to be performed on redologs), and when we do an insert on the source table, the replication end with an Error ORA-12899.
Interpretation: when doing the first refresh, the CDC read values form tables using "select table", so before passing the values Oracle decrypts the crypted fields, and the CDC replicate the corrects values on the target databases. with mirroring regim, CDC monitor the redolog and not tables, so the CDC get the encrypted value from redolog and is not aware that is an encrypted one and it try to insert the result of the encryption on the target database then the operation failed.
Please can any one help!