UNDO tablespace full
686167Oct 13 2009 — edited Oct 13 2009Hi all,
I've uploaded my db from 9i to 10g. The problem is, after all process (catupgrd.sql) when I start it, the undo tablespace appears always full:
tablespace_name total_size total_free %_free
-------------------- ---------- ---------- ----------
UNDO 256000 0 0
Now we've make a tablespace extend to 512M but, only the new extend appears free:
tablespace_name total_size total_free %_free
-------------------- ---------- ---------- ----------
UNDO 524288 268288 51.171875
Any idea to put all undo free?
Regards,
Jordi