I have a friend who has a website and asked me for help. I often use MySQL databases but never Oracle databases. And unfortunately he has an Oracle database, so I can't find a solution.
The available disk space is slowly decreasing... I delete a lot of lines from the table but that doesn't solve his problem. The database continues to take up disk space slowly.
I read that LOB files do not return disk space, even if you delete data.
- How can I reorganize LOB files easily with a simple request?
- (or/and) How can I recover disk space on Oracle?
SELECT DISTINCT VERSION FROM PRODUCT_COMPONENT_VERSION