Re: how to drop a datafile

From: <satar_at_my-dejanews.com>
Date: Thu, 15 Oct 1998 19:02:05 GMT
Message-ID: <705grd$hnd$1@nnrp1.dejanews.com>

The tablespace that belonged to the datafile is no longer valid, you will have to drop your tablespace as well.

Anyway...
NOARCHIVELOG Mode
ALTER DATABASE DATAFILE 'filename' OFFLINE DROP;

ARCHIVELOG MODE
ALTER DATABASE DATAFILE 'filename' OFFLINE;

In article <01bdf7ce$6afe0d40$53899cd1_at_default>, "Steve" <SCHEN_at_prodigy.net> wrote:
> Does anyone know how to drop a datafile which is offline and never to be
> able to be online?
>
> Thanks.
>
> Steve
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 15 1998 - 14:02:05 CDT