Oracle 9i replication
From: Ora_DBA <sanjaydharmadhikari_at_gmail.com>
Date: Thu, 23 Oct 2008 09:40:38 -0700 (PDT)
Message-ID: <c9708b6e-dc14-49c6-b0d0-cc6511ec18f5@j68g2000hsf.googlegroups.com>
Date: Thu, 23 Oct 2008 09:40:38 -0700 (PDT)
Message-ID: <c9708b6e-dc14-49c6-b0d0-cc6511ec18f5@j68g2000hsf.googlegroups.com>
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