Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Syntax for primary key tablespace

Syntax for primary key tablespace

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Thu, 24 Jun 1999 10:26:22 -0400
Message-ID: <3772400D.634304D@bigfoot.com>


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

Received on Thu Jun 24 1999 - 09:26:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US