creating primary keys in parallel>?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: creating primary keys in parallel>?

  1. #1

    creating primary keys in parallel>?

    Hi there,
    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)
    3 /
    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..

    Cheers,
    Bob

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width