Re: Drop a data file from a tablespace

The command helps you to take offline a corrupt file even if you are in noarchive mode. After that you have to drop the tablespace the file belongs to. There's no "alter tablespace drop datafile" command.

MK

MarkP28665 <markp28665_at_aol.com> wrote in article <1998050521124800.RAA12960_at_ladder03.news.aol.com>...
> From: yren_at_epsilon.com >>
> I am trying to drop a data file from a tablespace. I used command "alter
> database datafile file_name offline drop". The command ran fine, no error
> message, but when I check system view v$datafile or dba_data_files. The
data
> file was still there. Has anybody done this <<
>
> Check the file status. I believe it is 'invalid'. Also unless 7.3 has
had a
> change made to it, once you drop a datafile from a tablespace the
tablespace
> will need recovery. The last time we did this was with 7.1.6 so I
haven't
> reviewed the manuals for this recently, but I dought that this changed.
>
> Mark Powell -- Oracle 7 Certified DBA
> - The only advice that counts is the advice that you follow so follow
your own
> advice -
>
>
Received on Thu May 07 1998 - 00:25:14 CDT