From: "Dan" <dan1999a@home.com>
Newsgroups: comp.databases.oracle.server
References: <8rnhoj$c6i$1@nnrp1.deja.com>
Subject: Re: DataFile deleted ...
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <B2yE5.299319$i5.4328246@news1.frmt1.sfba.home.com>
Date: Tue, 10 Oct 2000 05:46:09 GMT
NNTP-Posting-Host: 24.176.181.68
X-Complaints-To: abuse@home.net
X-Trace: news1.frmt1.sfba.home.com 971156769 24.176.181.68 (Mon, 09 Oct 2000 22:46:09 PDT)
NNTP-Posting-Date: Mon, 09 Oct 2000 22:46:09 PDT
Organization: @Home Network


1. offline drop the datafile
        alter database datafile <dropped datafile> offline drop;
2. drop tablespace
        drop tablespace <tablespace_name>;

<dinos5@yahoo.com> wrote in message news:8rnhoj$c6i$1@nnrp1.deja.com...
> Hi all,
>
> I delete a data file by mistake, before dropping the corresponding
> tablespace. Thus, I cannot drop the tablespace because Oracle cannot
> find the datafile.
> Which is the solution to that problem?
>
> thanks in advance
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.