Generating a list of orphaned files and tables
You can use the cleanup utility to identify and output a list of orphaned temp files and tables.
Note: recommends
as a best practice that you output a list of identified orphaned files
and tables for verification before performing deletions using the
cleanup utility, rather than running the utility to immediately delete
files and tables. This can help prevent accidental deletes; there
is no recovery after deletion.