Originally posted by adewri
Hi

You need to create a new temporary tablespace before dropping the default temporay tablespace.

Create a new temporary tablespace
Code:
create temporary tablespace temp2
tempfile 'e:\oracle\oradata\orcl\temp2_01.dbf' size 500M;
then make it default temporary tablespace

Code:
alter database default temporary tablespace temp2;
now try to drop the temp tablespace

HTH
adewri:

He shud have got ORA-12906: cannot drop default temporary tablespace, instead he is getting Internal error code, if he were to drop defualt temp tablespace????

Will creating new Tablespace and making it defualt...& then droping other tablespace help????

I dont think it will.....

abhay.