Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: STREAMS capture and propagate to different schema
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.orgReceived on Wed Aug 02 2006 - 14:32:07 CDT