Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: STREAMS capture and propagate to different schema

Re: STREAMS capture and propagate to different schema

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 02 Aug 2006 12:32:07 -0700
Message-ID: <1154547128.348151@bubbleator.drizzle.com>


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:32:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US