2 Replies Latest reply: Apr 24, 2013 11:31 PM by Rc-Oracle RSS

    About Replication

    compuscience
      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
          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
            Rc-Oracle
            Hi,

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

            Thanks,
            Reena