Originally posted by akhadar
IT can.This what Oracle says.u need to have at least one temp tablespace.once u will create one more temporary tablespace as temp2 and drop the original temp tablespace all the users who are allocated to this temp tablespace will be allocate temp2 as the default temporaty tablespace.If u want u can test it.just now i did it successfully.
I did try as well.....

my point was ..... u cant get internal error when u try to drop temp tablespace with out having 1 more tablespace..... if so, ther might be some other probs asociated with it....
all u get is ORA-12906 and not ORA-00600

Abhay.