Q: recreate table with index on another tablespace

[Andy]

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.

[zhu chao]

you can use:
alter index pk_a rebuild tablespace user_indx;
us*****@yahoo.c om (Andy) wrote in message news:<ba******* *************** ***@posting.goo gle.com>...

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.