dr wrote:
> thanks Daniel.
> i should've mentioned i'm on 9.2.05.
>
> when i do anything but exactly match the schema and object, my apply
> doesn't work. the transactions are captured and propagated, however,
> they are not applied. in fact, there seem to be no errors.
>
> if you have a specific example of the package you mentioned, i'd be in
> your debt.
>
> thanks again,
>
> -r
>
> DA Morgan wrote:
>> dr wrote:
>>> thanks in advance!
>>>
>>> can anyone say definitively if i can or can't capture and propagate an
>>> object owned by one schema and apply that to a different schema on the
>>> destination database?
>>>
>>> as in a.dept (source database) changes captured and propagated to
>>> b.dept (target database).
>>>
>>> if this cannot be done 'out of the box,' any information pertaining to
>>> apply handlers to resolve this requirement (different schema names)
>>> would be much appreciated.
>>>
>>> -r
>> You can apply it to anything anywhere. Look at the DBMS_STREAMS_ADM
>> built-in package.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
Then you are SOL. No usable streams. And please do not top post.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Aug 02 2006 - 15:58:22 CDT
