My Oracle Support Banner

APPLY ABORTS WITH ORA-26687 AFTER STREAMS SETUP USING MAINTAIN_* SET OF PROCEDURES (Doc ID 1379065.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Following Note 864973.1 to setup Streams replication using DBMS_STREAMS_ADM.MAINTAIN_* set of procedures


exec dbms_streams_adm.remove_streams_configuration;
conn <STRMADMIN_USER>/<STRMADMIN_PASSWORD>
BEGIN
dbms_streams_adm.maintain_tables(
table_names => '<SCHEMA>.<TABLE>',
source_directory_object => '<SOURCE_DIRECTORY_OBJECT>',
destination_directory_object => '<DESTINATION_DIRECTORY_OBJECT>',
source_database => '<SOURCE DATABASE>',
destination_database => '<TARGET DATABASE>',
script_name => '<SCRIPT_NAME>',
script_directory_object=>'<SOURCE_DIRECTORY_OBJECT>',
capture_name => '<CAPTURE_NAME>',
apply_name => '<APPLY_NAME>',
capture_queue_name=>'<QUEUE_NAME>',
apply_queue_name =>'<QUEUE_NAME>',
perform_actions => TRUE,
bi_directional => FALSE,
include_ddl => false,
instantiation => dbms_streams_adm.instantiation_table);
END;
/


Streams setup is working fine. Apply may abort with an error ORA-26687 while insert,update or delete is being execute


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.