Re: How to remove Streams replication for a table
- From: amonte <ax.mount@xxxxxxxxx>
- To: vit.spinka@xxxxxxxxxxxx
- Date: Mon, 28 Jun 2010 23:42:30 +0200
Hi
I do use streams administrator but I cannot believe that we can setup
replication but cannot revert it?
If I have 20 tables being replicated but only want to get rid of one I have
to remove entire configuration and start over again for the 19 tables....? I
have been looking the docs, ML but nothing!
TIA
Alex
2010/6/28 Vit Spinka <vit.spinka@xxxxxxxxxxxx>
> Hi,
>
> perhaps the easiest way is to use a separate user for the configuration
> (like strmadmin in Oracle docs) and then drop it when you want to get
> rid of Streams and return to a clean state. And when you configure them
> again, you won't have problems with pre-existing links, queues etc.
>
> Or you can go the longer way, using dbms_streams_adm package.
>
> Vit
>
> Dne 27.6.2010 0:00, amonte napsal(a):
>
>> Hi all
>>
>> I am trying to replicate a few tables with Streams, it is very easy with
>> dbms_streams_adm.maintain_tables package.
>>
>> But I have a doubt after setting this up for around 10 tables, how do I
>> go back? i.e remove streams replication for a table?
>>
>>
>> TIA
>>
>> Alex
>>
>>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
