Re: Replication help
Date: 10 Oct 2001 11:07:06 -0700
Message-ID: <9f767483.0110101007.e709a48_at_posting.google.com>
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?
> Do I have to create manually those objects?
>
> 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
> ?
>
> Your help would be very appreciate.
> Thanks in advance.
>
> Chiku
Just replicate the tables. Indexes should be created at the replicated site for the following reason:
The requirement of the replicated site may be different and additional indexes may have to be created. Received on Wed Oct 10 2001 - 20:07:06 CEST