Re: Parallel table effects Index build why?

Server Tuning p 18-52

    "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 ?

--

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.
>
Received on Fri Sep 24 1999 - 09:56:00 CDT