a new user of oracle 10g.

tried the following statements on scott/tiger with tablespace x

create table mytest (
a varchar2(30)
);

alter table mytest
add constraint pk_a primary key(a);

alter table mytest
enable primary key using index
tablespace users_indx
pctfree 0;

drop table mytest cascade constraints;

sqlplus tells that the second alter statement has problem:
ora-00955: name is already used by an existing object.

May you explain me what is wrong with the statement and how to fix it
so that I can run the statements mupliple times? (if I drop the
tablespace clause in alter table it runs perfectly.)

Thanks very much.

you can use:
alter index pk_a rebuild tablespace user_indx;
usmle96 (AT) yahoo (DOT) com (Andy) wrote in message news:<bacee0b8.0406221011.1c834df (AT) posting (DOT) google.com>...