Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: snapshots
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