Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Plz help finding replication solution!
Yes, unfortunately there is a reason. If you really want to know why, I'll
tell you the story, but it's long and uninteresting :) Thanks for the tips,
I'll check those out.
"damorgan" <damorgan_at_exesolutions.com> wrote in message
news:3E0FDB1B.A79CF55D_at_exesolutions.com...
> tacnaboyz wrote:
>
> > Is it possible to replicate data from table1 INTO a pre-existing table2?
I
> > read up a bit on replication and it looks like a replicated table has to
be
> > a special replicated object. In other words, I have table2 that already
> > exists and I want to set up a replication process (read-only) that
mirrors
> > some columns of table1 into some columns in table2. I'll spare you the
> > nasty details as to why I can't be like everyone else and use the
> > 'traditional' replication methods. This process MUST take place on the
> > existing table2.
> >
> > Thank You!!!
>
> Is there any reason why Table2 can't be a materialized view?
>
> Either way ... look at DBMS_JOBS and AFTER triggers.
>
> Daniel Morgan
>
>
Received on Mon Dec 30 2002 - 07:47:42 CST