Operating System - HP-UX
1834215 Members
2049 Online
110066 Solutions
New Discussion

Cannot create CDC change set

 
Tom Reineri
New Member

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