I'm not quite sure what you're asking. If it's about the PK index,
you can specify a tablespace for that with a USING INDEX clause. If
you want all indexes for this table to go into a particular
tablespace, there's no simple way to do that; you'll have to specify
the tablespace in each CREATE INDEX statement, or change your default
tablespace.
--
Paul Baumgartel
paul.baumgartel_at_aya.yale.edu
On 7/27/05, John Dunn <jdunn_at_sefas.com> wrote:
> When creating the following table, how can I specify that indexes are
> created in a specific tablespace? I am happy for the table to be created in
> the default tablespace, but want to specify a different tablespace for the
> index(es)?
>
> Oracle version is 9.2
>
>
> CREATE TABLE VADADM.TBLPRIMARYKEY( AUTOINCREMENTE INTEGER , COLTYPE
> VARCHAR2(50)
> , ID INTEGER NOT NULL , ID_PARENT INTEGER , NULABLE VARCHAR2(3) , SQLTYPE
> INTEG
> ER , PSIZE INTEGER , LASTID INTEGER , NAME VARCHAR2(20) , PRIMARY KEY (ID),
> FORE
> IGN KEY (ID_PARENT) REFERENCES VADADM.tblTABLE);
>
>
>
> John Dunn
> Product Consultant
> Sefas Innovation Limited
> Direct Dial +44 (0) 117 373 6122
> www.sefas.com
>
> PLEASE NOTE SEFAS INNOVATION HAVE MOVED TO:
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK.
> Tel: +44(0) 117 373 6114
> Fax: +44 (0) 117 373 6115
> NEW DIRECT DIAL: +44 (0) 117 373 6122
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 27 2005 - 11:17:06 CDT
