Re: snapshots/data warehousing

David Pelinka wrote:
>
> I'm setting up an Oracle based data warehouse, and would like to know if
> anyone has experience with Oracle snapshots. We are running 7.1.6 and due
> to an Oracle bug, I'm unable to create a snapshot against a remote view
> that accesses multiple tables. (Oracle tells me this is fixed in 7.2.3).
> In the meantime, I'm using copy to move the data to the system where the
> data warehouse resides, but this is time consuming.
>
> 1. Is it faster to create a snapshot than a copy?
> 2. Do indexes against snapshots work well?
> 3. Have you used the scheduled refresh option of snapshots?
>
> Thanks.
>

David,

See my paper from last year's IOUG, "Managing Data Replication in Oracle7.0, 7.1, and 7.2". It covers these topics, and is too long to post here.

• Kevin Loney