This discussion is archived
2 Replies Latest reply: Apr 24, 2013 9:31 PM by reena - oracle RSS

About Replication

compuscience Newbie
Currently Being Moderated
how can i make replication for full user in oracle database 9i
i.e i need to replicate full user for anything done in it
  • 1. Re: About Replication
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    There is no "full user" method. Replication is by table or groups of tables (called Replication Groups). If you can group the tables by transaction definitions (e.g. a transaction touches tables A, B and C so all three will be in one Replication Group, provided that no other transaction touches tables B and Z !).

    See the Advanced Replication documentation for 9i.

    Do you want the replication site to be able to update data and/or propagate updates back to the master site ? Or do you need only read only copies of the data ? The former is much more complex to setup. The latter can be done using Materialized Views.


    Hemant K Chitale
  • 2. Re: About Replication
    reena - oracle Explorer
    Currently Being Moderated
    Hi,

    You can use streams and setup as schema level stream replication for replicating user from one DB to other DB.

    Thanks,
    Reena

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points