From: "Winnie Liu" <oracle_dba@zdnetmail.com>
Subject: Re: How to remove unrecoverable datafile?
Date: 1998/09/09
Message-ID: <6t7g3r$2g8@dfw-ixnews7.ix.netcom.com>#1/1
References: <01bddc61$be8e30d0$c70c400a@cms_bssup>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: ICGNetcom
X-NETCOM-Date: Wed Sep 09 10:12:59 PM CDT 1998
Newsgroups: comp.databases.oracle.server


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@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