dropping a datafile that is offline, temporary tablepsace

platform <Oracle 8.1.5 EE on Solaris 7)

Hi there

Having problems dropping a datafile from my Temp tablespace.

file is offline (needs recovery).

tried: alter database datafile <name> offline drop;

it returns and says statement processed but then when I do select name, file#, status from v$datafile where ts# = 2; it still shows the file as part of the tablespace.

any ideas.
pls email responces
george_at_is.co.za
thx

George Received on Fri Aug 25 2000 - 07:19:32 CDT