you cant drop datafiles from a tablespace anyway (without dropping the tablespace as well). However you can create a new undo tablespace for temporary work while you do whatever it is you need to do On 10/26/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote: > > Is there anyway to drop datafiles from an undo tablespace while the > database > is up (running in noarchivelog mode)? Or, do you have to startup nomount > and alter database drop datafile? >