Reclaiming space in an empty extent by unloading and re-creating or reloading a table

If the table does not include an index, you can unload the table, re-create the table (either in the same dbspace or in another one), and reload the data with the UNLOAD and LOAD statements or the onunload and onload utilities.

Copyright© 2018 HCL Technologies Limited