Re: alter database datafile offline drop

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 14 Feb 2001 21:36:51 +1100
Message-ID: <3a8a5fc4@news.iprimus.com.au>

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 - 04:36:51 CST