Convert permanent tablespace to temporary
Hello all,
I'm working on oracle 10g,
I created a tablespace TEMP1,
CREATE TABLESPACE TEMP1
DATAFILE 'D:\oracle\DISK2\temp1.dbf' SIZE 1M;
and I want to convert it to temporary tablespace so
I used:
Alter tablespace "TEMP1" TEMPORARY;
ERREUR Ó la ligne 1 :
ORA-10616: Operation not allowed on this tablespace
I don't understand why I cannot do that, knowing that there is absoletly nothing in my tablespace.
I know that I can drop it and create it as temporary, but I'm really curious to know why that doesn't work and how I can do it?
Best regards,
Baraa