RE: Dropping undo datafiles while db up

>> replace an undo tablespace with another undo 
>> tablespace while the instance is running.

I gave similar advise but from old RBS perspective.

But he actually and literary might just want to drop a single datafile (rather 
than create a new)?
Which can not be done in <= 9i, but I see here in another post can be done in 
10G R2.

Chris Marquez
Oracle DBA




-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Alex Gorbachev
Sent: Wed 10/26/2005 5:55 PM
To: cemail_219@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Dropping undo datafiles while db up
 
What's wrong with old good RTFM first?
This is for 10g:
http://oraclelon1.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams222.htm#sthref897

"UNDO_TABLESPACE specifies the undo tablespace to be used when an
instance starts up. If this parameter is specified when the instance
is in manual undo management mode, then an error will occur and
startup will fail.

If the UNDO_TABLESPACE parameter is omitted, the first available undo
tablespace in the database is chosen. If no undo tablespace is
available, the instance will start without an undo tablespace. In such
cases, user transactions will be executed using the SYSTEM rollback
segment. You should avoid running in this mode under normal
circumstances.

You can replace an undo tablespace with another undo tablespace while
the instance is running."

2005/10/26, J. Dex <cemail_219@xxxxxxxxxxx>:
> 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?
>
> _________________________________________________________________
> Don't just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l






Other related posts: