hi all ,
I'm recently completed stream tables level configuration one direction -- source and destination schema same
my question is can i configure stream replication from source database with schema name different to the schema destination like
can i make stream from scott.emp ------> xyz.emp
please help .....
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.