Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshots Simple vs. Complex

Re: Snapshots Simple vs. Complex

From: diversif <xnospamx.diversif_at_ix.netcom.com>
Date: 1997/06/11
Message-ID: <01bc7677$4d748940$5798b8cd@newmicronpc>#1/1

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 11 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US