Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to remove unrecoverable datafile?
Winnie Liu <oracle_dba_at_zdnetmail.com> wrote in article
<6t7g3r$2g8_at_dfw-ixnews7.ix.netcom.com>...
> You need to drop the whole tablespace that contains that datafile. Export
> all the objects of that tablespace, drop the tablespace and then recreate
it
> back.
>
> Winnie
Winnie,
Thanks for the reply... yuck, looks like a long piece of work for us!
Andy Received on Thu Sep 10 1998 - 08:46:42 CDT