hello:

The undo tablespace size is more than 5GB and my disk space is filling up fast.

I tried resizing the datafile and it fired with the ORA-03297.
and i guess it affects the performance.

I tried recreating new undo tablespace and assigning that and tried resizing old one. i got the same ORA-03297 error message.

how do we do it??.