CLEAN UNDO TABLESPACE
748245Jan 21 2010 — edited Jan 25 2010Hi Group
We need to free up an old UNDO tablespace (TS_ROLLBACK) because we have created a new one (TS_UNDO), ¿how can we do that?, we need to drop old UNDO tablespace but it keeps some extents active more than 4 days.
OWNER SEGMENT_NAME TABLESPACE_NAME EXTENT_ID FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO COMMIT_JTIME COMMIT_WTIME STATUS
SYS SYSSMU8$ TSROLLBACK 0 51 122 57344 7 51 ACTIVE
SYS SYSSMU8$ TSROLLBACK 2 104 8969 1048576 128 104 ACTIVE
SYS SYSSMU215$ TSUNDO 3 107 3593 1048576 128 107 ACTIVE
SYS SYSSMU229$ TSUNDO 0 107 6370 57344 7 107 ACTIVE
SYS SYSSMU229$ TSUNDO 3 107 46985 1048576 128 107 ACTIVE
SYS SYSSMU256$ TSUNDO 3 107 40073 1048576 128 107 ACTIVE
Thank you so much