My Oracle Support Banner

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.