Hi,
We have a streams database and while creating the capture process, i am getting the following unique constraint error in one of the system tables i guess. There is no data in gv$logmnr_session and there are no SYS invalid objects in the database.
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES(
table_name => 'SCHEMA_QOC.QOC',
streams_type => 'CAPTURE',
streams_name => 'CAPTURE_LOCAL_LCR',
queue_name => 'STREAMS_ADMIN.LOCAL_LCR',
include_dml => true,
include_ddl => false,
source_database => 'QMS2C.SIT.AMER.DELL.COM');
END;
/
ERROR at line 1:
ORA-00001: unique constraint (SYSTEM.LOGMNR_SESSION_UK1) violated
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 369
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 309
ORA-06512: at line 2
Please help.
] 
Blog
Search
Help
Members
Register
Login
Home
