how to shrink the undo tablespace
576856May 6 2009 — edited May 6 2009Hi,
we have one big table contains 1,000,000 records. due to arabic data corruption issue. we had to truncate this table and re insert again using flat file
(a) first we exported this table data into flat file ( txt file)
(b) truncate table big_table:
(c) re inserted again using flat file and commit at the end of insertion.
during this operation, i have seen my undo tablespace got increased from 2.5 GB to 11 GB.
I want to shrink this undo tablespace back to original size. is it safe to do?
DB : 9.2.0.7
OS: HP-UX 11.23
Moreover, the insertion operation is taking around 14 hours to complete (During week end, no other activity is going on other than this. I stopped listener before this operation starts). Any idea, how to reduce the insertion time??
Edited by: oraDBA2 on May 6, 2009 10:17 AM