RE: Dropping undo datafiles while db up

Not sure what you got into but likely any dropping of RBS/UNDO objects on a live system will cause problems.

Off the top of my head and more from the perspective of traditional RBS I think have done;

• create new RB tablespace (datafile)
• create new RB segments
• offline old RB segments
• drop old (now) offline RB segments
• drop old RB tablespace (datafiles)

This could be done on a live system, but not sure how this approach would work with existing UNDO tablespace (auto UNDO segments)?

hth,

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of David Sharples Sent: Wed 10/26/2005 10:09 AM
To: cemail_219_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Dropping undo datafiles while db up  

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