how to shrink undo tablespace on 10GR2?
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 19 Oct 2010 07:43:51 -0700 (PDT)
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:
