My Oracle Support Banner

Streams Apply Process Fails With ORA-1435 For DDLs In a 11gR2 Spoke Database (Doc ID 1341962.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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


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

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