Re: how to specify index tablespace in table create

From: L120bj <l120bj_at_aol.com>
Date: 1997/04/07
Message-ID: <19970407201700.QAA06393@ladder01.news.aol.com>#1/1

The method you are trying to use is for unique constraints, but the constraint you have specified is a not null constraint, so the 'using index tablespace clause' is not valid.
If you just wish to create a non-unique index on a specific column within a table this cannot be done as part of the create table command and must be done using create index ...

Hope this helps,
  Rob

---

---

Subject: how to specify index tablespace in table create From: evert vandeworp <Evert.M.Vandeworp.1_at_nd.edu> Date: Sun, 06 Apr 1997 13:40:28 -0500
Message-ID: <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;

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 Mon Apr 07 1997 - 00:00:00 CDT