Home » Server Options » Streams & AQ » unique constraint (SYSTEM.LOGMNR_SESSION_UK1) violated (10.2.0.3)
unique constraint (SYSTEM.LOGMNR_SESSION_UK1) violated [message #466812] Wed, 21 July 2010 04:54
adit_me1
Messages: 49
Registered: October 2007
Location: BANGALORE
Member
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.
Previous Topic: Error at create capture process
Next Topic: 10R2 Source/ 11gR2 Target applies to wrong destination
Goto Forum:
  


Current Time: Thu Mar 28 09:22:02 CDT 2024