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_at_hotmail.com> 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?
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 26 2005 - 09:12:00 CDT
