using PARALLEL in ALTER TABLE

From: David F. Newman <buzzwang_at_roanoke.ourvillage.com>
Date: Fri, 28 Jan 2000 15:55:07 GMT
Message-ID: <86wvoumbne.fsf@roanoke.ourvillage.com>

I've been trying to add a primary key to a table and it won't allow me to use the PARALLEL clause.

ALTER TABLE dave.my_table ADD CONSTRAINT pk_my_table PRIMARY KEY (col1, col2)
USING INDEX TABLESPACE test_idx
STORAGE (initial 2047M next 512M minextents 3) PARALLEL (DEGREE 6) NOLOGGING; It gives me this error.
ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified The recommendation given by oerr is

// *Action: Remove all but one of the PARALLEL or NOPARALLEL clauses and // reissue the statement.

Well, duh. But I only have one PARELLEL clause.

However, PARALLEL with CREATE INDEX works.

CREATE INDEX dave.idx1_my_table ON dave.my_table (col1, col3) TABLESPACE test_idx
STORAGE (initial 2047M next 512M minextents 3) PARALLEL (DEGREE 6) NOLOGGING; Does anyone have any suggestions as to what I'm doing wrong?

--
David F. Newman
Oracle DBA
buzzwang_at_ourvillage.com Received on Fri Jan 28 2000 - 09:55:07 CST