GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

ORA-00001: unique constraint (SYSTEM.LOGMNR_SESSION_UK1) violated

edited Sep 24, 2013 9:07PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center