Hi all,

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