Return
-
Title
How to defragment or coalesce an Oracle Tablespaces? -
Description
How to defragment or coalesce an Oracle Tablespaces?
-
Resolution
The Coalesce feature in Toad can be accessed by going to the Schema Browser | Tablespaces Tab | right-click a Tablespace | click on “Coalesce tablespace“.
You can also go to the Database Menu | Diagnose | Tablespaces Map | choose a Tablespace from the drop-down list | click on the “Coalesce” icon.
NOTE: A database usually automatically performs coalesce on Tablespaces in which case changes might not be realized even after you manually perform a coalesce in Toad.