Transparent Data Encryption TDE - garbage/non-standard data shows up in this TDE column.
RE: oracle version 10.2.0.4
Encryption type: ENCRYPT USING 'AES192' NO SALT
I implemented Transparent Data Encryption(TDE) on September 20th. The garbage/non-standard data start showing up from the next day data load as follows with some of the records:
ä}·
¬R·
¤7þ¶
¿ä¯
P
º´
ë³
The table we implemented TDE has 95 partitions. As part of the data load, we add a new partition and drop old partition everyday. Since I ran TDE on September 20th for the entire table (95 partitions), I am surprised that I don't see garbage/non-standard data in history prior to September 20th.After September 20th, I see this non-standard data everyday for some of the records. this column is VARCHAR2(20 BYTE) and most of the time we receive dollar amount.
I implemented Transparent Data Encryption(TDE) on September 20th. The garbage/non-standard data start showing up from the next day data load as follows with some of the records:
ä}·
¬R·
¤7þ¶
¿ä¯
P
º´
ë³
The table we implemented TDE has 95 partitions. As part of the data load, we add a new partition and drop old partition everyday. Since I ran TDE on September 20th for the entire table (95 partitions), I am surprised that I don't see garbage/non-standard data in history prior to September 20th.After September 20th, I see this non-standard data everyday for some of the records. this column is VARCHAR2(20 BYTE) and most of the time we receive dollar amount.
0