Streams Apply Process Fails With ORA-1435 For DDLs In a 11gR2 Spoke Database

(Doc ID 1341962.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


In a Hub and Spoke Configuration, which contains a 10g Hub database, the Apply process fails with ORA-1435  for DDLs on a 11.2 Target spoke database.

The issue could surface in a stream setup having the following configuration

-  Source spoke database - Any version
-  Hub database               -  Version 10g
-  Target spoke database  -  Version 11.2

This error would occur only for configuration that contains a 10g Hub Database for which the fix for bug 9553883 is not applied


Upgrade of  a target spoke database to 11.2, in an all 10g Hub and Spoke Configuration


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms