Re: how to specify index tablespace in table create

Evert,

The using index clause is only valid with unique and primary key constraints, not
check constraints such as not null.

Phil Cook

evert vandeworp <Evert.M.Vandeworp.1_at_nd.edu> wrote in article <3347EE1C.495A_at_nd.edu>...
> i'm trying to specify the index tablespace in the create table statement
> so that
> i can separate my tables and indexes onto different disks. the way i
> read the manual,
> this should work:
>
> CREATE TABLE printer(
> internal varchar2(8) CONSTRAINT printer_internal_nn NOT NULL
> USING INDEX TABLESPACE indexes,
> printer_name varchar2(16) CONSTRAINT printer_printer_name_nn NOT NULL
> USING INDEX TABLESPACE indexes,
> description varchar2(24)
> )
> TABLESPACE data;
>
>
Received on Mon Apr 07 1997 - 00:00:00 CDT