Re: dropping a datafile that is offline, temporary tablepsace

"George Leonard" <george_at_is.co.za> wrote in message news:39a66370$0$225_at_hades.is.co.za...
> 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.

Try dropping the tablespace now (and then re-creating it obviously!). HJR
>
> any ideas.
> pls email responces
> george_at_is.co.za
> thx
>
> George
>
>
Received on Sat Aug 26 2000 - 16:27:27 CDT