0

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
12.1.0.1.0

0

Only deleting lines from tables will not gain the disk space. You need to reclaim the table space after deleting data.

I would suggest go through the Oracle documents on reclaiming space.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.