RE: Dropping undo datafiles while db up
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: <davidsharples@xxxxxxxxx>, <cemail_219@xxxxxxxxxxx>
- Date: Wed, 26 Oct 2005 10:53:12 -0400
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@xxxxxxxxxxxxx on behalf of David Sharples
Sent: Wed 10/26/2005 10:09 AM
To: cemail_219@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@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?
>
Other related posts:
