Replication help
Date: 4 Oct 2001 09:41:07 -0700
Message-ID: <a5a9456c.0110040841.196c01eb_at_posting.google.com>
We are using oracle8i, we decided to replicate one of the production
schema. Our requirement for replication is read-only snapshot which
needs to be refreshed every 2 hours.
That schema has following objects in database.
40 Tables
80 Indexes
50 Views
5 Sequence
5 Triggers
Now my question is I can s/u read-only snapshot with fast refresh on
those 40 tables, but what about other objects (e.g. Indexes, views
etc..)?
What will happen if any DDL happen on one of those table? What I have
to do, so that particular DDL will replicate/applied to snapshot site
How they will replicate?
Do I have to create manually those objects?
Your help would be very appreciate.
Thanks in advance.
Chiku Received on Thu Oct 04 2001 - 18:41:07 CEST