Re: Q: recreate table with index on another tablespace

you can use:
alter index pk_a rebuild tablespace user_indx; usmle96_at_yahoo.com (Andy) wrote in message news:<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 Fri Jul 02 2004 - 10:49:14 CEST