Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Create indexes in specific tablespace
I have a question re creation of indexes in a specific tablespace.
How can I amend the following to ensure any idexes are created in a tablespaced called INDEXES, rather than the default tablespace?
CREATE TABLE TBLCOLUMNS(
ID INTEGER NOT NULL ,
SQLTYPE INTEGER ,
PSIZE INTEGER ,
COLTYPE VARCHAR2(50) ,
NULABLE VARCHAR2(3) ,
NAME VARCHAR2(20) ,
ID_PARENT INTEGER ,
PRIMARY KEY (ID), FOREIGN KEY (ID_PARENT) REFERENCES TABLTABL
E);
John
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 10 2005 - 04:21:30 CST
![]() |
![]() |