Re: Resetting the instantiation SCN

On 5 May, 23:20, Pedro Lopes <pedro.lo..._at_netvisao.pt> wrote:
> Hi Tarby,
> that can be done in an easy way.
>
> Look at the streams documentation for TAGS.
>
> Basically you'll need to :
>
> - Check the current session tag.
> - Write it down.
> - Alter the tag to a different value - this will avoid the apply process
> to apply the next created LCRs.
> - Do your DML / Process
> - Commit;
> - Set the TAG to the original value.
>
> This will avoid any changes made with the new TAG to be applied on the
> target databases.
>
> Hope it helps,
> Pedro.

That's a great solution, Pedro - it works really well, thankyou. I guess the one thing I have to be careful of is that our upgrade script sometimes changes the database connection; it might do some stuff as SYSTEM, then it might reconnect as the user who owns the application schema to do some more stuff, and so on. What I see from my tests this morning is that DBMS_STREAMS.SET_TAG only affects the current connection... it's not global, so any time I change connection, I'll also have to set a non-null tag again.

Thanks again,
Tarby Received on Tue May 08 2007 - 05:02:13 CDT