cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot create CDC change set

Tom Reineri
Occasional Visitor

Cannot create CDC change set

I'm trying to recreate CDC after dropping everything.
Received this msg below trying to create change set CDC_SET_DEV06_TM -- after change set CDC_SET_DEV06_EAI was created without error.
Any suggestions are greatly appreciated.
Thanks,
Tom

Error at line 100
ORA-26668: STREAMS process CDC$A_CDC_SET_DEV06_EAI exists
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3366
ORA-06512: at "SYS.DBMS_AQADM", line 167
ORA-06512: at line 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_CDC_SYS_IPUBLISH", line 417