I have an Oracle XE database with several tablespaces. One of these is used to store image data, and this tablespace has grown to a huge size. We decided that we didn't need to the images any more so deleted them all.
This has freed up a lot of space but the tablespace size is still huge. How can I reduce it back to the size of the data that's actually in it?
I would do a full database export, drop the tablespace, create a new tablespace with a smaller size and import back into it