Re: Snapshot questions

76434.1353_at_compuserve.com (Ton) wrote in message news:<4477604.0303231017.4c01a313_at_posting.google.com>...
> I have some questions about creating a snapshot environment
> (Oracle realease 8.17.4i Windows NT)
>
> What do I need:
>
> - Replicate Master Table A + indexen to a Remote server "Snapshot"
> - Snapshot data is READ-Only
> - Data refresh oneway every hour " FAST" and one time day "Complete"

If this is all that you need, you don't really need to go through all the replication steps. Just

1. Create a materialized view log on the master table.
2. Create a read-only materialized view (make sure it is fast refreshable) on the materialized view site, specify hourly refresh interval.
3. Schedule a job to do the daily complete refresh.
4. Sync. steps 2 and 3.

Fairly simple. You don't need to rely on OEM either.

• Jusung Yang