SecureFile LOB doesn't release space after deleting
I have a table with one SecureFile LOB column. After deleting most of the rows, the LOB segment remains large (25GB). If I make a copy of that table with CREATE TABLE… AS SELECT *…., the copy-LOB segment is only 1GB in size.
I've tried to change the RETENTION from NULL to NONE, but it didn't help.
Any advice is welcome.