Sample Header Ad - 728x90

Oracle 10g remove unused dbf

0 votes
1 answer
63 views
I deleted a tablespace that I no longer needed, and I accidentally left out the SQL query to delete the files. The tablespace has been deleted but the DFB has been left in the operating system path. I was wondering what the best way to delete it would be, since it is taking up unnecessary space. I have not dared to execute a rm -f file.dbf lsof does not indicate that any process is using it, but I think it would be better to do it from the DB itself if possible. System: RHEL4 Oracle Database: 10.2 Thanks!
Asked by fah81 (15 rep)
Sep 24, 2024, 04:40 PM
Last activity: Sep 24, 2024, 08:43 PM