This content has been marked as final. Show 3 replies
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.