Does Drop Table Free up Space Oracle

Dropping a table will free up the space within the database, but will not release the space back to Windows. That requires shrinking the database file.

Does DROP TABLE free up space?

Dropping a table will free up the space within the database, but will not release the space back to Windows. That requires shrinking the database file.

How do I free up space in Oracle tablespace?

  1. Create a new tablespace.
  2. Move the segments to the new tablespace.
  3. Resize the original datafile.
  4. Move the segments back to the original tablespace.
  5. Drop the new tablespace.
David Miller

David Miller

Executive Financial & Market Analyst

David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.

Share this article
Twitter Facebook Pinterest