creating primary keys in parallel>?
we are currently reorganising our main database - some 220Gb of data. I can rebuild the indexes with a parallel clause but no primary keys...see below
SQL> ALTER TABLE "REUSABLE_DEMO_TABLE" ADD CONSTRAINT "PK_ID" PRIMARY KEY (PK_ID)
2 USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE OEM_ORIGINAL_DATA01 NOLOGGING parallel (degree 4)
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE OEM_ORIGINAL_DATA01 NOLOGGING parallel (degree 4)
ERROR at line 2:
ORA-03001: unimplemented feature
-Anyone got any suggestions on how to get around this? Is it just the case that pk creation isnt supported in parallel or is my syntax wrong?
Any ideas? Some of our big PKs take 3-4 hours to run each, while equivalent plain indexes in parallel are taking 30-40 mins. Our windor for reorging the whole database is fixed and limited so we need to speed this up..
create the index first, then add the pk. the index does not have to be unique, and i pefer myself to keep it non-unique so that the pk can be defined as deferrable.
Click Here to Expand Forum to Full Width