Re: primary key using index parallel

Hi Gerard,

the way to do that is to create unique index first (for that primary key) and enable
the primary key afterwards. E.g.

create unique index table_a_pk...
....
parallel (degree n);

alter table table_a add constraint
table_a_pk primary key(.....)
...

parallel (instances n) is used only with parallel server. It determines the number
of parallel server instances used in the parallel operation.

"Gerard H. Pille" wrote:

> Hello,
>
> Is it possible to specify the degree of parallellism (eg "parallel
> (instances 2)") when creating an index for a primary key constraint? As in
> :
>
> alter table table_a
> add constraint table_a_pk primary key (column_a)
> using index
> tablespace ts_a
> parallel (instances 2);
>
> The above gives syntax errors, Oracle reads this as if I wanted to change
> the parallellism of the table.
>
> Kind Regards,
>
> Gerard
Received on Mon Apr 12 1999 - 07:38:09 CDT