In much the same way as with the Undo tablespace, you may want to reduce the size of the Temp tablespace in Oracle to reclaim space. 11g —- ALTER TABLESPACE [tbsp_name] SHRINK SPACE KEEP 30M; 10g and earlier —————— Unfortunatly, if the temp tablespace is full (as will be the case if it has …
There is no function in Oracle (up to 11g currently) that will allow you to reduce the size of the undo tablespace. Sometimes you will need to free up space and the best way to get it will be to reduce the size of the undo tablespace. The way to do this is basically to …
When data is changed in the oracle database, the information needed to undo the changes is recorded so that the change can be undone (Rolled back). The record is basically just the original information. Information is recorded in rollback segments and the undo tablespaces. This information is also used to provide read consistency which allows long running transactions …