My Oracle Support Banner

Streams Changes Propagated to Target But Not Applied - Source Has No Domain Name and Destination Does Have a Domain Name (Doc ID 1126744.1)

Last updated on DECEMBER 10, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Information in this document applies to any platform.


When attempting to implement Oracle Streams between a source with no domain name as part of its global name and target with a domain name in its global name, it is observed that changes are propagated to the target but not applied. There are no errors.

Further investigation reveals that the source database name used at the target in several key areas has had the target's domain name appended to it, even though there is no such domain name in the global name at the source. This is observed in:
For example, if the source global name is RED, and the target global name is BLUE.WORLD, setting up Streams between these using normal methods can result in the source database name RED.WORLD appearing in the views above at the target. This difference between the actual source global name and the source global name recorded in the target views will result in LCRs from the source being discarded by the target apply process.


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.