Re: Replication help

chiku_patel_at_yahoo.com (chiku) wrote in message news:<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..)?
> How they will replicate?
You should not try to replicate indexes, sequences, triggers or views.  You will have to recreate them at each location.

> Do I have to create manually those objects? Yes. Its easiest to make a script.
>
> 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
> ?
You need to stop the fast refresh and regenerate a full refresh. - Patrick
>
Received on Fri Oct 05 2001 - 18:59:07 CEST