Re: Parallel table effects Index build why?

From: Ajk <amos.kudirka_at_firstdatacorp.com>
Date: Wed, 29 Sep 1999 13:50:17 GMT
Message-ID: <7st5ei$2n5$1@nnrp1.deja.com>

I found that TWO LINE statement!
It would be more clear if Oracle documented the way you wrote it. "You must supply NOPARALLEL."
Thanks again.
Cheers,
Amos

In article <938445631.7453.0.nnrp-13.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> The 7.3.3 Version. Part No. A48506-1, Oct 31 1996
>
> You will need to supply the NOPARALLEL
> explicitly (or try PARALLEL (degree 1, instances 1)
> if NOPARALLEL does not work.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Ajk wrote in message <7snui4$bre$1_at_nnrp1.deja.com>...
> >
> >
> >In article <938185367.3247.0.nnrp-04.9e984b29_at_news.demon.co.uk>,
> > "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> >>
> >> Server Tuning p 18-52
> >Thanks Jonathan for your reply - still have questions.
> >
> >What Server Tuning Book are you refering to?
> >I have several and I do not find anything definitive on the statment
> >you wrote below.
> >
> >>
> >> "By default, the Oracle Server uses the
> >> table definition's parallel clause."
> >>
> >> What syntax are you using to tell Oracle
> >> not to create the index in parallel ?
> >
> > I supplied no syntax on the DDL I let it default of NOPARALLEL!
> >>
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 29 1999 - 08:50:17 CDT