Speaking of weird replication things... Has anyone
tried doing an standard ANALYZE command on the
RUPD$... table. (On my install, 8.1.6+) it says that
it worked but always gives null stats...Not important
- but hmmmmm
Connor
- "A. Bardeen" <abardeen1_at_yahoo.com> wrote: > That
restriction was lifted in Oracle8 since
> deferrable constraints were introduced. Referential
> integrity and unique constraints are allowed on
> snapshots as long as they are created as deferrable
> since, as Connor mentioned, the uniqueness cannot be
> guaranteed during the refresh. Non-unique indexes
> are
> also allowed.
>
> They are created the same way as on a normal table.
> In 8.0.x they're created on the SNAP$_ base table;
> in
> 8i the table name is identical to the snapshot/MV
> name.
>
> HTH,
>
> -- Anita
>
>
> --- Connor McDonald <hamcdc_at_yahoo.co.uk> wrote:
> > You can but make sure they are non-unique, since
> > Oracle does not give any guarantees of uniqueness
> > during a refresh
> >
> > hth
> > connor
> >
> > --- Vikas Kawatra <VKawatra_at_innoventry.com> wrote:
> >
> > Has anyone created indexes on MV's ? Syntax? URLs
> ?
> > >
> > > thanks
> > > vikas
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Vikas Kawatra
> > > INET: VKawatra_at_innoventry.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> > FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
> > > access / Mailing Lists
> > >
> >
>
> > > To REMOVE yourself from this mailing list, send
> an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing:
> UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> >
> > =====
> > Connor McDonald
> > http://www.oracledba.co.uk (mirrored at
> > http://www.oradba.freeserve.co.uk)
> >
> > "Some days you're the pigeon, some days you're the
> > statue"
> >
> >
>
> > Do You Yahoo!?
> > Get your free @yahoo.co.uk address at
> > http://mail.yahoo.co.uk
> > or your free @yahoo.ie address at
> > http://mail.yahoo.ie
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?Connor=20McDonald?=
> > INET: hamcdc_at_yahoo.co.uk
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail -
> only $35
> a year! http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: A. Bardeen
> INET: abardeen1_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Jun 05 2001 - 13:39:41 CDT
