Re: STREAMS capture and propagate to different schema

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
Received on Wed Aug 02 2006 - 14:47:06 CDT