Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Syntax for primary key tablespace
Indexes should be on different drives than tables, therefore,
is there a convenient syntax to do this from the start?
create table x (a NUMBER primary key a)
tablespace y
will just throw them both in y. Does it have to be separated into
a create table and alter statement to separate the default created
index?
so that alter x add constraint....using tablespace zz. or something?
(That's the way I'm going to do it, just wondered if any other ideas).
![]() |
![]() |