parallel requires more space and often times you will not have enough
spaces for parallel rebuild process even you have enough free space for
your final index. I ran into this problem before. you may use no
parallel hint to disable the option.
ted chyn
In article <7snui4$bre$1_at_nnrp1.deja.com>,
Ajk <amos.kudirka_at_firstdatacorp.com> wrote:
>
>
> 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!
> >
> > --
> >
> > Jonathan Lewis
> > Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
> >
> > Ajk wrote in message <7sg0mg$3ms$1_at_nnrp1.deja.com>...
> > >7.3.4
> > >2 wide 4 CPU nodes AIX running PQO, and PSO
> > >I have a table that is parallel degree of 8 instance 2.
> > >
> > >Problem Description:
> > >A coworker ran a create Non-Unique index and it abended with:
> > >ORA-12801: error signaled in parallel query server p008, instance 2
> > >ORA-01658: unable to create INITIAL extent for segment in
tablespace
> > >What-ever
> > >
> > >My question: I only have the table eligiable for parallel. Why
> > >is the index using the table settings? The index is set to no
> parallel.
> > >
> > >No where in any of the tuning books says the index build will use
> > >the table parallel settings!
> > >
> > >
> > >Sent via Deja.com http://www.deja.com/
> > >Before you buy.
> > >
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Sep 27 1999 - 18:09:28 CDT
