how to solve ORA-31421: change table does not exist
Oracle EXADATA
Oracle database 11g
I have created oracle CDC in my test environment.
Even though I have faced below error while I created change table, table wa created as normal table in the db. Actually, This table [cdcpub.trans_ct] should be in change_tables. But there is no table in change_tables; how to solve it? Thanks in advance.
BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE(
owner => 'cdcpub',
change_table_name => 'TRANS_CT',
change_set_name => 'CHANGESET_SIT',
source_schema => 'MYUSERSIT',
source_table => 'TRANS',
column_type_list => 'ID NUMBER(18), CREATED TIMESTAMP(3), TYPE_ NVARCHAR2(24), LAST_MODIFIED TIMESTAMP(3),STATE NUMBER(5)',