Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dropping undo datafiles while db up

Re: Dropping undo datafiles while db up

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Wed, 26 Oct 2005 23:55:22 +0200
Message-ID: <c2213f680510261455w2746cc53t@mail.gmail.com>


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_at_hotmail.com>:
> 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
Received on Wed Oct 26 2005 - 16:57:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US