Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> no parallel when building primary key
can anyone tell me why the following sql returns an oracle 12812 error:
alter table tablename add constraint pk_tablename primary key
(column1,
column2)
using index storage (initial 1m next 1m)
pctfree 0
parallel 4
/
ORA-12812:
12812, 00000, "only one PARALLEL or NOPARALLEL clause may be specified"
// *Cause: PARALLEL was specified more than once, NOPARALLEL was specified
// more than once, or both PARALLEL and NOPARALLEL were specified
// in a CREATE TABLE, CLUSTER, or INDEX or in an ALTER TABLE or
// CLUSTER statement, or in a RECOVER command.
// *Action: Remove all but one of the PARALLEL or NOPARALLEL clauses and
// reissue the statement.
thanks in advance
-maurice
samuels_at_seas.upenn.edu
Received on Mon Jan 08 2001 - 16:42:21 CST