how to manually deallocate undo space in Oracle 10g..Its a bit urgent.. Thanks SachinOracle LazyDBA home page