Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replication between different schema in same database

578096Jun 11 2009 — edited Jun 12 2009

Hi All,

Am having an urgent query in replication. Am having a datbase db1 with schema1 and schema2. Both having a table named table1.

Updation in the table1 in schema1 should get replicated to table1 in schema2. Can we use replication for this scenario?

I can't create any triggers on the table. Because it will affect the exsiting structure (Which is not allowed).

What kind of replication can be used. Any other technology or ideas to implment this automatic updation?

Please help me.

Regards,
P

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2009

Added on Jun 11 2009

#database-key-features, #replication

11 comments

4,016 views