Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> primary key index on separate tablespace not possible?
We generally have tables and indexes on separate tablespaces. However, I find that the following does not work:
alter table t_name add constraint t_name_pk primary key (column_name) tablespace ts_name;
Without using "tablespace ts_name" the above works except that the index is created on the same tablespace as for the table itself.
Can anyone confirm that this is true or my syntax is wrong.
Thanks
Richard Received on Wed Jun 07 2000 - 00:00:00 CDT