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
Last activity: Sep 24, 2024, 08:43 PM