Oracle 9i replication
Date: Thu, 23 Oct 2008 09:40:38 -0700 (PDT)
I need help with Oracle 9i replication. I have some experience with basic replication with read only snapshots in Oracle 8i.
I have 2 master databases, Database A and B. Database C is a "slave" database.
I need to replicate tables T1 and T2 from database A and tables T3 and T4 from database B into database C.
Database C is going to host read only snapshots or materialized views of these 4 tables. These tables are in separate schemas.
My questions are:
- Is it possible to configure replication in this way?
- Oracle 9i documentation talks about multimaster replication and creating REPADMIN and other accounts with some privileges. Is it necessary to do all that for the simple scenario I described above?
- Can I just create snapshot logs in database A, B and read-only materialized views in database C ( the way Basic Replication works in Oracle 8i) ?
- Do I neeed to create materialized view logs?
Any other information that might be relevant will be greatly appreciated. If someone can describe steps I need to execute to implement this type of replication, that would be a great help.
Thanks in Advance. Received on Thu Oct 23 2008 - 11:40:38 CDT