Click to See Complete Forum and Search --> : How to create an index in temporary tablespace


veerla
October 5th, 2001, 01:25 AM
Hi,

In oracle,I created a new database and TEMP tablespace got automatically created.

Then, I created MYOWN tablespace and created a table in MYOWN tablespace.

I tried to create an index for this table in TEMP tablespace.

CREATE INDEX index1 ON table1(column1) TABLESPACE TEMP;

It gave me an error saying:
ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace.

Creating this index in TEMP tablespace is essential for me.

Could you please suggest me, how to solve this problem.

Thanks in advance,
Veerla.