Re: how to drop a datafile

Offline of a datafile is not the same as offline of a tablespace. The drop option on offline of a datafile does not drop the file it only allows the offline in circumstances where it will be impossible to recover the file. Once you offline drop a datafile you must also drop the tablespace to avoid allocation in the datafile. There is no means of dropping just one file out of a tablespace. There is nothing wrong to reuse the a file number once the old file has been dropped from the database with its tablespace.

satar_at_my-dejanews.com wrote:

> 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 Fri Oct 16 1998 - 18:29:11 CDT