My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2019

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.

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 => '<SCHEMA>.<CHANGE_TABLE_NAME>',
source_table_name => '<SCHEMA>.<TABLE_NAME>',
column_type_list => '<column_name_1>,<column_name_2>,<column_name_3>,',
extra_column_list => 'command_type,commit_scn',
capture_values => '*',
perform_actions => true,
capture_name => '<CDC_CAPTURE_NAME>',
propagation_name => '<CDC_PROPAGATION_NAME>',
apply_name => '<CDC_APPLY_NAME>',
source_database => '<SOURCE_DB_WITH_DOMAIN>',
destination_database => '<TARGET_DB_WITH_DOMAIN>');
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


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