Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshots Simple vs. Complex
Please try out before posting any comments. I am having a snapshot running successfully which is built on a view.
Bala.
diversif wrote:
>
> Don't think that you can create a snapshot off of a view. One of the
> columns in the SNAP$ table is the ROWID of the master row. Views don't
> have ROWIDS.
>
> Claude R. Garalde <crgaral_at_pacbell.com> wrote in article
> <339C9DDD.310D_at_pacbell.com>...
> > Oracle definition's of a simple snapshot is one
> > where the snapshot is based on a single row in a
> > single remote table. Complex snapshots have
> > definitions that include the GROUP BY, or CONNECT
> > by clauses, or subqueries, joins, or set
> > operations.
> >
> > My question is: If you create a view that joins
> > two Master tables, then create a snapshot of the
> > view, is the snapshot a simple or complex
> > snapshot?
> >
> > My guess is it's a complex snapshot, but I am
> > unable to find documentation that would confirm my
> > suspicion. Anyone know for sure?
> >
> > Please e-mail direct crgaral_at_pacbell.com - Thanks!
> >
Received on Wed Jun 18 1997 - 00:00:00 CDT