This content has been marked as final. Show 3 replies
Yes and this process is described in the manual. Check for transform functions
See the metalink note:
How to TRANSFORM a Schema Name in Streams using Declarative Rule Transformations [ID 784126.1]
But, I noticed that the DDLs will not be replicated in Oracle 10g when you use a different schema name at destination. However, all DMLs will be replicated.
thanks you for this information