How to decomission the Specific streams [message #440555] |
Mon, 25 January 2010 11:23 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
tapaskmanna
Messages: 98 Registered: January 2007 Location: Cyprus,Nicosia
|
Member |
|
|
Hi,
We have five Oracle Streams:
Streams Name CAPTURE PROCESS APPLY PROCESS
1. AE at AA Database at AB Database
2. AG at AA Database at AB Database
3. AF at AA Database at AB Database
4. AT at AA Database at AB Database
5. AK at AA Database at AB Database
All the above five Streams are active.
How to decomission the AT & AK streams only i.e. (i.e. removal of streams from AA Database (CAPTURE PROCESS) and the AB Database (APPLY PROCESS)).
Please suggest.
[Updated on: Mon, 25 January 2010 11:24] Report message to a moderator
|
|
|
|
|
|
Re: How to decomission the Specific streams [message #492576 is a reply to message #492573] |
Tue, 01 February 2011 04:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
The title says: "Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit".
Use DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION to remove Streams.
But as you are now in the middle of the process I don't know how it will behave.
Regards
Michel
|
|
|