ORA-01435 Error In MAINTAIN_CHANGE_TABLE Environment
Last updated on JUNE 17, 2014
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Both the Source and Target databases in this case are 22.214.171.124 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".
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms