shrink space in tablespace
We have a table named MAM_ASSETS, one of whose columns is BLOB. We have the option to keep our files in BLOB form or store them on a file server and keeping the link somewhere in other column of MAM_ASSETS.
We provide the option to move data from BLOB column to file server that vacates space. BLOB column data is stored in some tablespace.
When we move the data from BLOB column to file server, the space in BLOB tablespace is not released. Is there a way to release this space?