Re: Syntax for primary key tablespace

On Thu, 24 Jun 1999 10:26:22 -0400, Doug Cowles <dcowles_at_bigfoot.com> wrote:

Hi, try this:

create table x (
  a number,
  constraint pk_a primary key (a)
    using index tablespace ts_index
)
tablespace ts_data;

>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).
>
>- Dc.

___
Fred Stojentin Received on Thu Jun 24 1999 - 11:01:01 CDT