This content has been marked as final. Show 3 replies
Just to understand your requirement , are all three MV1 , MV2 and MV3 materialized view sites pointing to SDB database ?
Now what is the relation between SDB and DDB* databases?
MV1, MV2 and MV3 all are in Source DB i.e. "SDB" under schema "MS_Schema".
The above three MVs need to be streamed over to different destination DB i.e DDB1, DDB2 and DDB3 using oralce Stream.
My Question is whether it is possible to Stream as follow:
MV1 to DDB1
MV2 to DDB2
MV3 to DDB3
I think we can use hub-spoke mechanism for this type of stream but not sure if different things can from the source DB can be streamed to different destination DBs.
It's possible to stream the date of single source objects to multiple destinations.