Re-page Oracle tables after removing CLOB fields
One way to "re-page the table" is to use the ALTER TABLE... MOVE command. Behind the scenes Oracle will make a temporary copy of the table and switch to that copy. If your table has a lot of unused space in blocks then you might be able to reclaim some of that after the move. If your table has any indexes you will need to rebuild them. I struggled to find a good documentation link for MOVE but try this one.