By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,874 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,874 IT Pros & Developers. It's quick & easy.

Q: recreate table with index on another tablespace

P: n/a
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.
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
you can use:
alter index pk_a rebuild tablespace user_indx;
us*****@yahoo.com (Andy) wrote in message news:<ba*************************@posting.google.c om>...
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.

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.