Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: snapshots
I have used snapshots for two reasons:
1- Replication (set up a snapshot on database b of tables on database a)
2- Performance, where a view is needed for a report or suite of
reports, but rebuilding the view each time is too time expensive. I
build a snapshot in off hours which can then be used for reporting
without the rebuild overhead of a view. This is true particularly for
multiple reports against the same view/snapshot.
In article <7mdfg3$49c$1_at_news.worldonline.nl>,
"Kasper Kombrink" <kombrink_at_dds.nl> wrote:
> Hi I am kinda new to this group, and I have the following question!
> When do you use Snapshots? Why not use views instead? And is there
any good
> documentation around how to use Snapshots?
>
> TIA
>
> Kasper
> kombrink_at_dds.nl
>
>
--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Jul 12 1999 - 16:03:55 CDT
![]() |
![]() |