Re: Create indexes in specific tablespace
- From: malcolm arnold <malcolmarnold@xxxxxxxxx>
- To: jdunn@xxxxxxxxx
- Date: Thu, 10 Nov 2005 10:36:18 +0000
> How can I amend the following to ensure any idexes are created in a
> tablespaced called INDEXES, rather than the default tablespace?
You have to create the table, then add the primary key in separate DDLs:
CREATE TABLE TBLCOLUMNS(
ID INTEGER NOT NULL ,
SQLTYPE INTEGER ,
PSIZE INTEGER ,
COLTYPE VARCHAR2(50) ,
NULABLE VARCHAR2(3) ,
NAME VARCHAR2(20) ,
ID_PARENT INTEGER)
alter table TBLCOLUMNS
add PRIMARY KEY (ID)
using index tablespace my_tablespace
alter table TBLCOLUMNS
add FOREIGN KEY (ID_PARENT) REFERENCES TABLTABLE(ID)
Malcolm.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
