Oracle 9i replication

From: Ora_DBA <>
Date: Thu, 23 Oct 2008 09:40:38 -0700 (PDT)
Message-ID: <>

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:

  1. Is it possible to configure replication in this way?
  2. 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?
  3. 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) ?
  4. 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

Original text of this message