Re: drop datafile from tablespace

There is no command to drop a file from tablespace. offline drop can give you lots of problems when your tablespace is about to run out of space. Read Oracle Backup and Recovery Handbook - Case studies chapter.

fh_at_wad.org (Frank Hoerper) wrote:

>Hi,
 

>(HP 9.x / Oracle 7.0/7.2)
 

>a few days ago I add a datafile to an existing tablespace. It works fine
>and because it was only a test I want to drop/delete the datafile from the
>the tablespace. I don't know exactly the command, because
>I'm not in the office yet, but it was something like
 

>alter tablespace <name> offline drop;
 

>I got the message "Statement processed" but a
>"select * from dba_data_files" shows me, that the datafile was still there.
>But the physical file associated with the datafile was still deleted, so that
>I can't set the tablespace offline. Can someone give me a hint, what I
>have to do, if I wan't delete a datafile from the tablespace. Or is it
>right, that the datafile-entry appears on the select statement after
>dropping the datafile from tablespace ?
 

>bye
> Frank