DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: drop a primary key

  1. #1
    Join Date
    May 2005
    Posts
    17

    drop a primary key

    Hi,

    I want to speedup import of data into a table, by dropping all
    indexes first. How can i drop an index used for inforcement of
    unique/primary key?

    drop index emp_id_pk; got ora-2429

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    nice to see you did some research first!!!

    once of

    ALTER TABLE xxx DROP PRIMARY KEY
    ALTER TABLE xxx DROP CONSTRAINT pk_xxx;
    ALTER TABLE xxx DROP CONSTRAINT pk_xxx
    CASCADE CONSTRAINTS;

  3. #3
    Join Date
    May 2005
    Posts
    17
    thanks

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