How to get inside Streams?
edited Oct 10, 2011 12:40AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
(Almost certainly in the wrong group, here - apologies - please feel free to point me in the right direction)
I'm starting to work with Oracle Streams (11.1.0.7) and have successfully replicated changes from one table to another.
Now I'm experimenting with how to "manage" them, i.e. monitoring them and fixing problems when they happen.
So, I deliberately caused a problem by changing the "apply_user" for one of my apply processes to a user with no privileges on the target table and, lo and behold, the apply process failed (and promptly disabled itself) and I get a record in the Error Queue.
I'm starting to work with Oracle Streams (11.1.0.7) and have successfully replicated changes from one table to another.
Now I'm experimenting with how to "manage" them, i.e. monitoring them and fixing problems when they happen.
So, I deliberately caused a problem by changing the "apply_user" for one of my apply processes to a user with no privileges on the target table and, lo and behold, the apply process failed (and promptly disabled itself) and I get a record in the Error Queue.
0