ORA-31536: / ORA-28350: cannot encrypt the specified column recorded in CDC synchronized change table:- Solution

ORA-28350: cannot encrypt the specified column recorded in CDC synchronized change table

ORA-31536: cannot support encrypted column  in the source table

Solution:- You can use Encrypted tablespace with encryption algoritham for the source table


create tablespace encrypt_data_tbl  datafile '/app/oracle/oradata/orcl/encrypt_data01.dbf' size 100m ENCRYPTION USING 'AES256'  DEFAULT STORAGE (ENCRYPT);


ALTER TABLE EMP_MASTER MOVE TABLESPACE ENCRYPT_DATA_TBL;


EXEC DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE (....);