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 and indexes

Re: Snapshots and indexes

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/03/12
Message-ID: <38cc2690.489283879@news.earthlink.net>#1/1

read about deferred indexes. (8 feature)

On 08 Mar 2000 09:36:15 EST, crimmins_at_nospam.us.easyphone.com (Steven Crimmins) wrote:

>Hi,
>We have a snapshot from a local Oracle 8 to a remote Oracle 8 that
>uses fast refreshes (a refresh group goes every half hour).
>
>Is it possible to create an index on this local snapshot table? Are
>there any gotcha's to doing this?
>
>Thanks
>Steve



In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email
Received on Sun Mar 12 2000 - 00:00:00 CST

Original text of this message

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