ORA-00001: unique constraint (SYSTEM.LOGMNR_SESSION_UK1) violated
I had to rebuild stream. Let me explain the sequence of events.1. App team ran a huge delete which was running for 2 days and 18 hrs.
2. They killed the process but it was still blocking lots of things.
3. We recycled the database
4. Tried to rebuild stream
This is what I am getting
SQL> BEGIN
2 DBMS_STREAMS_ADM.ADD_TABLE_RULES(
3 table_name => 'SNG.EFM_MEASDAILY',
4 streams_type => 'CAPTURE',
5 streams_name => 'MEAS_CAPTURE',
6 queue_name => 'STRMADMIN.MEAS_QUEUE',
7 include_dml => TRUE,
8 include_ddl => FALSE,
9 include_tagged_lcr => TRUE,
10 source_database => '&1..WORLD',
11 inclusion_rule => TRUE,
12 and_condition => ':lcr.get_compatible() <= dbms_streams.compatible_11_1');
0