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