ORA-26665 When Creating A Capture Process or an Apply process (Doc ID 279666.1)

Last updated on SEPTEMBER 07, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

When attempting to add rules to the rule set for an existing capture process using
DBMS_STREAMS_ADM.ADD_TABLE_RULES (or similar procedure) you get ORA-26665: STREAMS
process CAPTURE01 already exists. Both the capture process and the queue exist.

SELECT capture_name FROM dba_capture;

CAPTURE_NAME
------------------------------
STRM01_CAPTURE

SELECT name FROM user_queues;

NAME
------------------------------
AQ$_ORDERS_QUEUETABLE_E
ORDERS_QUEUE
AQ$_STREAMS_QUEUE_TABLE_E
STREAMS_QUEUE


BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES(
table_name => 'oe.order_items',
streams_type => 'capture',
streams_name => 'capture01',
queue_name => 'IX.streams_queue',
include_dml => TRUE,
include_ddl => TRUE,
include_tagged_lcr => FALSE,
inclusion_rule => TRUE);
END;
/

BEGIN
*
ERROR at line 1:
ORA-26665: STREAMS process CAPTURE01 already exists
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 369
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 309
ORA-06512: at line 2

This problem can also happen when trying to create an Apply process

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms