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.

Comments embedded.

On Oct 23, 11:40*am, Ora_DBA <sanjaydharmadhik... (AT) gmail (DOT) com> wrote:
Then use Streams.

Possibly, but it's outdated technology. Use Streams.

For that, yes, but use Streams and you'll probably be happier.

Why? Streams will replicate all of the data for all of the tables you
want to copy, and you simply grant select-only access to them to the
interested users.

If you insist upon using materialized views and want fast refreshes,
yes. And in 9i these are the same as the old snapshot logs of 8i
lore.

Use Streams. Use Streams. Use Streams.


David Fitzjarrell

Comments embedded.

On Oct 23, 11:40*am, Ora_DBA <sanjaydharmadhik... (AT) gmail (DOT) com> wrote:
Then use Streams.

Possibly, but it's outdated technology. Use Streams.

For that, yes, but use Streams and you'll probably be happier.

Why? Streams will replicate all of the data for all of the tables you
want to copy, and you simply grant select-only access to them to the
interested users.

If you insist upon using materialized views and want fast refreshes,
yes. And in 9i these are the same as the old snapshot logs of 8i
lore.

Use Streams. Use Streams. Use Streams.


David Fitzjarrell

Comments embedded.

On Oct 23, 11:40*am, Ora_DBA <sanjaydharmadhik... (AT) gmail (DOT) com> wrote:
Then use Streams.

Possibly, but it's outdated technology. Use Streams.

For that, yes, but use Streams and you'll probably be happier.

Why? Streams will replicate all of the data for all of the tables you
want to copy, and you simply grant select-only access to them to the
interested users.

If you insist upon using materialized views and want fast refreshes,
yes. And in 9i these are the same as the old snapshot logs of 8i
lore.

Use Streams. Use Streams. Use Streams.


David Fitzjarrell

Comments embedded.

On Oct 23, 11:40*am, Ora_DBA <sanjaydharmadhik... (AT) gmail (DOT) com> wrote:
Then use Streams.

Possibly, but it's outdated technology. Use Streams.

For that, yes, but use Streams and you'll probably be happier.

Why? Streams will replicate all of the data for all of the tables you
want to copy, and you simply grant select-only access to them to the
interested users.

If you insist upon using materialized views and want fast refreshes,
yes. And in 9i these are the same as the old snapshot logs of 8i
lore.

Use Streams. Use Streams. Use Streams.


David Fitzjarrell

David,
Advanced Replication/Streams used to be an Enterprise Option.
I get the impression, this is a license issue...

To the OP: yes; simply use MV's and MV logs on the source
side (if you wish to use fast refreshes)
--

Regards,
Frank van Bortel

David,
Advanced Replication/Streams used to be an Enterprise Option.
I get the impression, this is a license issue...

To the OP: yes; simply use MV's and MV logs on the source
side (if you wish to use fast refreshes)
--

Regards,
Frank van Bortel

David,
Advanced Replication/Streams used to be an Enterprise Option.
I get the impression, this is a license issue...

To the OP: yes; simply use MV's and MV logs on the source
side (if you wish to use fast refreshes)
--

Regards,
Frank van Bortel

David,
Advanced Replication/Streams used to be an Enterprise Option.
I get the impression, this is a license issue...

To the OP: yes; simply use MV's and MV logs on the source
side (if you wish to use fast refreshes)
--

Regards,
Frank van Bortel