Re: how to shrink undo tablespace on 10GR2?
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 19 Oct 2010 08:00:16 -0700 (PDT)
You can create a new UNDO tablespace of the size you want, but if you set the
files to autoextend you'll end up where you are now. You might also try
starting the database in restricted mode to see if that clears the HWM for UNDO
and allows you to shrink it further.
David Fitzjarrell
________________________________
From: dba1 mcc <mccdba1@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Cc: oracle-db-l@xxxxxxxxxxxxxxxxxxxx
Sent: Tue, October 19, 2010 10:43:51 AM
Subject: how to shrink undo tablespace on 10GR2?
We have 10GR2 on Linux server. I found one database "undo" tablespace has been
extend to 32 GB size. I used 'dba_free_space" to check and found this data
file
actually is empty. I tried to "resize" it back to small size but I can only
resize it to 28GB. I knew this may be cause by "high water mark".
Does there has way to shrink it to small?
Thanks.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
