Xref: alice comp.databases.oracle.misc:54233
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!logbridge.uoregon.edu!news.nero.net!news.uidaho.edu!sea-feed.news.verio.net!news.sierra.com!not-for-mail
From: "Steve McDaniels" <steve.mcdaniels@sierra.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: snapshots
Date: Fri, 3 Mar 2000 12:35:17 -0800
Organization: Sierra On-Line, Inc.
Lines: 65
Message-ID: <89p80e$2ko$1@plo.sierra.com>
References: <38B43F55.AD28E427@Unforgettable.com> <951342262.12336.0.pluto.d4ee154e@news.demon.nl> <38B53581.A5C6D554@Unforgettable.com>
X-Trace: plo.sierra.com 952116046 2712 209.67.71.100 (3 Mar 2000 20:40:46 GMT)
X-Complaints-To: usenet@plo.sierra.com
NNTP-Posting-Date: 3 Mar 2000 20:40:46 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700

Just an aside here. When you finally get the dist. option

installed/corrected,

be mindful of the rollback segments / sizes on the two systems.

7.x does not permit specifying which (system's) rollback segment to use.

I have a 7.x system on one side (data mart), an 8.x system (transactional)

on the other.

I want to have a snapshot of one of the 8.x's tables on the 7.x's side.

The rollback segments on the 8.x side are many, but small.

As a result, I cannot use Oracle's snapshot without either dramatically

enlarging the 8.x's RBS

or upgrading to 8.x on the 7.x system so that I could specify which (side's)

rollback seg. to use.

Also, ya should fix the parallel query option == must have!

create index I on T (FIELD_NAME)

parallel (degree 4)

tablespace TABLESPACE_NAME

storage (....)

This baby runs in about half the time vs. not using parallel.

"K Stahl" <BlueSax@Unforgettable.com> wrote in message
news:38B53581.A5C6D554@Unforgettable.com...
> Sybrand Bakker wrote:
> >
> > issue select * from v$option on both databases and you will know which
> > options have been installed.
> >
> > The distributed option should be included with all flavors of Oracle
except
> > for Personal Oracle I believe.
> >
>
>
> Here is the result of that query:
>
> procedural      TRUE
> distributed     FALSE
> replication     FALSE
> parallel query  FALSE
> Parallel Server FALSE
> Spatial Data    FALSE
>
> I didn't install oracle originally on this machine. Does this mean that
> whoever did the installation did not make a correct choice when running
> orainst? If so, is this something that can be corrected? This was
> originally a 7.3.4.0 installation and recently I applied the patch to take
> it up to 7.3.4.4.