Oracle 18.104.22.168.0 on Win2000.
My TEMP tablespace is created as LMT, AUTOEXTEND ON.
Its size somehow reached to 30GB.
So, I decided to drop and recreate it.
I have issued the
drop tablespace TEMP including contents;
But it is taking long time to complete the command.
I heared that if it is a LMT, it drops real quick.
It also does not show anything in fet$ for TEMP tablespace.
What should I do?
Thanks in Adv.