ORA-01435 Error In MAINTAIN_CHANGE_TABLE Environment (Doc ID 1683512.1)

Last updated on JUNE 17, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Both the Source and Target databases in this case are 11.2.0.3 version.

Running MAINTAIN_CHANGE_TABLE procedure to setup local Capture and Remote apply, without replication, as follows:

BEGIN
DBMS_STREAMS_ADM.MAINTAIN_CHANGE_TABLE(
  change_table_name => 'MYCDC.MDEPT_CT',
  source_table_name => 'SCOTT.MDEPT',
  column_type_list  => 'DEPTNO NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13)',
  extra_column_list => 'command_type,commit_scn',
  capture_values => '*',
  perform_actions => true,
  capture_name => 'CDC_CAPTURE',
  propagation_name => 'CDC_PROP',
  apply_name => 'CDC_APPLY',
  source_database => 'SRC.US.ORACLE.COM',
  destination_database => 'TGT.US.ORACLE.COM');
END;
/

As seen above, the change_table is owned by a different schema than the source table.

An UPDATE of 1 row to the table results in APPLY ABORTING .
The error_message in dba_apply_error is "ORA-01435: user does not exist".

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