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 -> how to specify index tablespace in table create

how to specify index tablespace in table create

From: evert vandeworp <Evert.M.Vandeworp.1_at_nd.edu>
Date: 1997/04/06
Message-ID: <3347EE1C.495A@nd.edu>#1/1

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.edu
Received on Sun Apr 06 1997 - 00:00:00 CST

Original text of this message

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