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 and later
Information in this document applies to any platform.


Both the Source and Target databases in this case are 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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.