Q: recreate a table with index in anothor tablesapce

I am a new user of Oracle using 10g. Got the problem when sub following sql statements:

• simple test

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 second alter table has error: ora-00955: name is already used by another existing object.

At least I found if comment out the tablespace clause, everything runs fine. may you explain what is wrong with this statement? and how to fix it?

Thanks very much. Received on Tue Jun 22 2004 - 15:09:39 CDT