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: Delayed block cleanout and changing automatic undo tablespace

RE: Delayed block cleanout and changing automatic undo tablespace

From: Tim Onions <tim.onions_at_speechmachines.com>
Date: Tue, 20 Jul 2004 11:20:21 +0100
Message-ID: <A90A3AC3D202D311909A0090271E4C810321094E@SMCORPS0002> 





Many thanks for the fast response. Sorry to ask a dumb question but with
AUTO UNDO in 9i how can one "...offline the undo segments..". There are no
active transactions on the segments in the old large undo tablespace show
via V$transaction.



Thanks



T¬




Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.


--



Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Received on Tue Jul 20 2004 - 05:17:31 CDT












Original text of this message













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