Re: alter database datafile offline drop

Howard, that is actually what I ended up doing. A junior DBA is in training, and she thought she could do that and get rid of data files :-)

"Howard J. Rogers" wrote:

> You can NEVER remove datafiles from a tablespace once they've been added to
> it. The best you can do is to resize them to something trivial.
>
> After an offline drop, you're supposed to then drop the entire
> tablespace -otherwise, the files remain in 'recovery' status for ever.
> Bouncing an Instance shouldn't be a problem, but that's not a state I'd be
> happy leaving lying around for ever and a day.
>
> Regards
> HJR
>
> "kipnukpup" <kipnukpup_at_netscape.net> wrote in message
> news:3A89FACD.9DEF7635_at_netscape.net...
> > Running Oracle 8.1.6 on Solaris 2.7
> >
> > What are the consequences of issuing this command?
> > We had a database where there were too many datafiles created,
> > and this command was issued. However, the status of the datafiles
> > dropped now says "recover".
> > If we shut down this Instance, will it even come back up - I'm not sure
> > what the status should say now that
> > it's been dropped?
> >
> > Thanks
> >
Received on Wed Feb 14 2001 - 14:56:20 CST