How to resolve a full disk issue in an Oracle database?

When the disk space of an Oracle database is exhausted, the following measures can be taken to resolve the issue:

1. Clean up log files: Use the command ALTER SYSTEM SWITCH LOGFILE to switch the current log file to a new one, and then delete the old log file. This will help free up some disk space.
2. Clean up temporary tablespace by using the command ALTER TABLESPACE TEMP ADD TEMPFILE to add a new temporary tablespace file and delete the old one. Temporary tablespace is typically used for sorting and temporary result sets, so it can help free up some disk space.
3. Remove unnecessary files: Check the database for unused files, such as old backup files, log files, temporary files, and delete them to free up disk space.
4. Compress tablespace: Use the ALTER TABLESPACE SHRINK SPACE command to compress the tablespace in the database and release unused space.
5. Increasing disk space: If the above methods do not solve the problem, you may want to consider adding disk space. This can be done by adding a new disk drive or expanding an existing one.
6. Data migration: If the disk space of the database is running out, one option is moving some infrequently used data to either an archive or archival database in order to reduce the storage requirements of the current database.

The above are some common solutions, the specific steps may vary depending on the database version and environment. It is recommended to back up the database before implementing these solutions to prevent data loss.