Re: How to remove unrecoverable datafile?

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: 1998/09/09
Message-ID: <6t7g3r$2g8@dfw-ixnews7.ix.netcom.com>#1/1

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

Andy Hardy wrote in message <01bddc61$be8e30d0$c70c400a_at_cms_bssup>...
>Hi,
>
>I have a datafile which is shown as requiring recovery. I cannot recover as
>the required archive log is missing. This is not important as the datafile
>contains no tables, etc.
>
>I've tried an 'offline drop' of the datafile, which produces no error but
>the file continues to be shown as part of the system and requiring
>recovery.
>
>I'm running Oracle 7.3 NT.
>
>Any ideas?
>
>Andy
Received on Wed Sep 09 1998 - 00:00:00 CDT