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

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;

thanks