Q: recreate table with index on another tablespace
From: Andy <usmle96_at_yahoo.com>
Date: 22 Jun 2004 11:11:56 -0700
Message-ID: <bacee0b8.0406221011.1c834df_at_posting.google.com>
a new user of oracle 10g.
Date: 22 Jun 2004 11:11:56 -0700
Message-ID: <bacee0b8.0406221011.1c834df_at_posting.google.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. Received on Tue Jun 22 2004 - 20:11:56 CEST