Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> primary key using index parallel

primary key using index parallel

From: Gerard H. Pille <ghp_at_skynet.be>
Date: 12 Apr 1999 08:25:05 GMT
Message-ID: <01be84bf$27c20800$390120c0@GHP.creyfs.be>


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 - 03:25:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US