Unable to drop tablespace
Hi,
I am Converting from dictionary managed PERMANENT "temp" tablespace to localy managed temp tablespace.
1. created "temp2" and assigned as default and temporary tablespace.
2. no permanent objects in "temp"
3. Seven segments exist in temp of type temporary
4. tablespace temp offline
4. Drop tablespace including hangs at :
select file#, block# from seg$ where type# = 3 and ts# = :1
I have even all datafiles offline.
Any way to drop this tablespace without system restart ?
thanks in advance.