Clean Full Oracle Tablespace: Step-by-Step

When the Oracle tablespace is full, you can clean it up with the following steps:

1. Check the usage status of the tablespace:
2. Retrieve the tablespace names and their corresponding usage percentages from the database table “dba_tablespace_usage_metrics.”
3. Clean up temporary files in the tablespace.
4. Resize the database temporary file named ‘temp_file_name’ to xxx megabytes.
5. Clean up log files in the table space.
6. Retrieve the group number and member information from the v$logfile view.
   Then, alter the database to drop the logfile group specified by the group number.
7. Clean up the rollback segments in the tablespace.
8. Retrieve the name of the rollback segment from the database and adjust its storage by setting an optimal size of xxxM.
9. cleaning up data files in the tablespace
10. Resize the database data file named ‘data_file_name’ to xxx megabytes.
11. Clean up unused objects and indexes in the table space.
12. Get the owner and segment name from the dba_segments where the tablespace name is ‘tablespace_name’.

    Remove the table table_name and the index index_name.

Please make sure to back up important data before cleaning up the table space, and proceed with caution based on the actual situation.