6 Replies Latest reply: Jun 1, 2012 4:01 AM by Mrshah-Oracle RSS

    Schema to Schema replication


      We have a kind of requirement where we have 2 exact schema's with some 450 tables (on same database). Now whenever there is any insert/update/delete on schema1.table1 then same changes should be applied on schema2.table1 (same database)... The difference between 2 schema is that there is one extra column in all tables of schema1 which should not be available on schem2 tables.

      The thing that we can do is to write a trigger for each 450 tables... but i don't think that would be the best solution.. can someone please suggest what could be the better way to implement this..?

      Thanks and Regard!