This content has been marked as final. Show 2 replies
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
You can use streams and setup as schema level stream replication for replicating user from one DB to other DB.