Q: recreate table with index on another tablespace

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. Received on Tue Jun 22 2004 - 13:11:56 CDT