Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> how to specify index tablespace in table create
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;
but i get the error:
internal varchar2(8) CONSTRAINT printer_internal_nn NOT NULL USING INDEX TABLESPACE indexes,
* ERROR at line 2: ORA-00907: missing right parenthesis
can anyone help?
-- Evert Vandeworp Network Analyst vandeworp.1_at_nd.eduReceived on Sun Apr 06 1997 - 00:00:00 CST