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

Home -> Community -> Usenet -> c.d.o.misc -> Re: snapshots

Re: snapshots

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Fri, 3 Mar 2000 12:35:17 -0800
Message-ID: <89p80e$2ko$1@plo.sierra.com>


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_at_Unforgettable.com> wrote in message news:38B53581.A5C6D554_at_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.
Received on Fri Mar 03 2000 - 14:35:17 CST

Original text of this message

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