GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Is it possible to change the global name in an existing streams configuration (and make any supporti

edited May 13, 2016 5:23AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓

Is it possible to change the global name in an existing streams configuration (and make any supporting changes in streams to keep everything straight?  Or must you redo stream setup after the change?

Since I'm afraid I know the answer... I know it is possible to restream tables without copying data... but I don't know the steps... can anyone point me to a good example?

Our streams implementation is all symetric bidirectional.

Basic plan is to halt updates, "unstream" as needed, change global name and create new, correct DB links, and re-stream the tables specifying that matching structures and data already exists.  (To avoid copying a lot of data and minimize time and space issues associated with recopying everything.)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center