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...
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?
- Create a new tablespace.
- Move the segments to the new tablespace.
- Resize the original datafile.
- Move the segments back to the original tablespace.
- Drop the new tablespace.