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 184.108.40.206 and later
Information in this document applies to any platform.
Both the Source and Target databases in this case are 220.127.116.11 version.
Running MAINTAIN_CHANGE_TABLE procedure to setup local Capture and Remote apply, without replication, as follows:
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');
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".
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
|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.|