Re: Create indexes in specific tablespace

> 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.

--
http://www.freelists.org/webpage/oracle-l